| CLR (view all ...) | Last Post | Replies |
|
| Youtube Geyser 1st Video Traffic Marketing Solution www.youtubegeyser.com | 29 Nov 2008 04:19 GMT | - |
YouTubeGeyser Will Let You: Drive people to your video niche to any of your existing websites! Just choose the plan you need and you have a couple of Traffic Don't miss your chance...
|
| Send Free SMS Worlwide to any mobile phone iphone gsm http://free4sms.info | 29 Nov 2008 03:42 GMT | - |
Free4sms is a free service. Send SMS for Free worldwide to any mobile phone gsm, iphone, smart phone. use it with moderation. http://free4sms.info/
|
| How to pass SQL table type parameter INTO C# CLR SQL stored procedure | 18 Nov 2008 14:05 GMT | 2 |
Hi. Thank you for your expertise. I am trying to find out how ot pass data in SQL Server 2008 table type into C# CLR stored procedure from SQL stored procedure. I've found lots of references how to pass it out of CLR procedure to SQL procedure but none the other way. My plan is: ...
|
| TVF and SPs behave differently in Management Studio and from ADO | 15 Nov 2008 18:24 GMT | 1 |
Using SQL Server 2005 and .NET 3.5. I have a SQL stored procedure [collection and validation of parameters] which references some CLR table valued functions [some complex mathematics]. The table valued functions, in turn, call a SQL stored procedure doing
|
| Deploy C# stored procedures | 12 Nov 2008 22:12 GMT | 3 |
We have the OurStoredProcedures.dll with stored procedures in C#. We programatically deploy these stored procedures to the local SQL Server, using SQL command with the "CREATE PROCEDURE ..."statement. Also we are creating an assembly on the server.
|
| multiple-input user defined aggregates | 30 Oct 2008 02:53 GMT | 3 |
Where can I find a tutorial/samples of "multiple-input user defined aggregates"?
|
|
| Connectivity (view all ...) | Last Post | Replies |
|
| I have dysfunction in SQL Server 2008 Express | 01 Dec 2008 20:54 GMT | 5 |
I have dysfunction in SQL Server 2008 Express I'm sorry to bother you, but I have no one else to ask. I installed on my computer C# 2008 Express and SQL Server 2008 Express. And I cannot change values in database tables.
|
| connect in other server domain | 01 Dec 2008 20:52 GMT | 1 |
I must to connect in sql server using authentication windows, but the database is in other network with other domain, when I connect using authentication sql , work fine, but I must to use authentication windows thank youn in advance
|
| Access filtering allows changes to SQL Database | 01 Dec 2008 19:25 GMT | - |
I have a weird occurrence. We are using SQL2005 & Access 2000 (also happens with Access 2007). We connect the Access DB to SQL with an ODBC with a logon that should have read only connection to SQL. Everything works as expected except one field.
|
| 'Login failed' using tsql from Ubuntu | 01 Dec 2008 17:21 GMT | 4 |
Hopefully I am posting in the right newsgroup... I am trying to troubleshoot an issue with a user who needs to access a SQL 2000 database from Ubuntu. He is passing the following command which is generating the error below (I've blocked out the IP Address): tsql -H XXX.XXX.XXX.XXX ...
|
| Unable to connect to the right SQL Server database | 30 Nov 2008 20:30 GMT | 4 |
First, a confession. I posted this question earlier today in microsoft.public.vsnet.general (which I now think was the wrong Discussion Group). Now, if you're willing to read further... I'm setting up a new VB.Net and
|
| Limit number of connections per database | 30 Nov 2008 17:18 GMT | 2 |
In SQL 2005 is it possible on the server to limit the number of connections per database?
|
|
| SQL (view all ...) | Last Post | Replies |
|
| Calculate Power | 01 Dec 2008 21:48 GMT | 2 |
I am trying to perform the following calculation 100^(-.01*25) Here is the code I have right now declare @decay_rate decimal;
|
| SSIS | 01 Dec 2008 21:25 GMT | 1 |
I want to migrate data from a source database to a destination database... There's only one table to transfer. One of the column in the source table contains 5 prices separated by a space....
|
| bcp syntax help | 01 Dec 2008 21:24 GMT | 2 |
I'm trying to export a table contents with date limitation using bcp command. The date is going to be variable. My command is like this, I'm sure I'm missing something, it gives me saying "syntax error converting datetime from char string..."
|
| Sequential ID That Resets Each Day | 01 Dec 2008 21:22 GMT | 3 |
I have a need to have an ID --which is a sequential number-- that starts over at 0 each day; however, I obviously also need to have a unique way of identifying each individual record. You can think of it as being similar to the registers at some fast food restaurants where each ...
|
| RULE | 01 Dec 2008 20:59 GMT | 4 |
I am unable to drop a rule. Does anyone know the magic trick to dropping a rule?
|
| a union query | 01 Dec 2008 20:51 GMT | 9 |
I am using the following statement to select top 10 visited product. But i want to show the total hit number for other all products which are not in first 10. SELECT TOP 10 COUNT(*)AS TOTAL_HIT , STOCK_CODE FROM B2B_WEB_LOG
|
|
| XML (view all ...) | Last Post | Replies |
|
| insert binary data from xml | 26 Nov 2008 21:40 GMT | 2 |
Hi, i have to "bulk" insert in my table some binary values (files) reading from xml text.. i use this way: create table test(MyKey varchar(32), FileData varbinary(MAX));
|
| Shred XML Data into Columns/Rows | 26 Nov 2008 13:03 GMT | 2 |
I have a XML as below. As you may see, the ErrorMessage node has several "Error" nodes with attributes and data. Now, I want to get those attribute names as "columns" and the values in "rows".. (Action, Key, MultiRefId, Batch... are the columns).
|
| Can I use ../@mp:localname? | 20 Nov 2008 19:12 GMT | 4 |
I need to get the name of the parent node and used "../@mp:localname" in the openxml statement. I got an error when trying to execute the query: XML parsing error: Reference to undeclared namespace prefix: 'mp' However, the query execute just fine if I use @mp:localname. It seems ...
|
| Multiple XML insert using SQL Server 2008 DML and Correlated Where subquery? | 18 Nov 2008 12:51 GMT | 1 |
I would like to insert an XML fragment into multiple records as efficiently as possible. This SubQuery at the end returns a list of UserId's I would like to run the DML insert statement against. This is what I have so far. I don't get an error but nothing happens.
|
| XQuery join nodes | 17 Nov 2008 19:38 GMT | 2 |
Hi, Is there a way to join nodes using for loop. for example i have <name> <alt>test1</alt>
|
| XML query result | 14 Nov 2008 18:28 GMT | 1 |
In SQL Server 2005 SP2, when I use a query like this: SELECT f1, f2, f3 from myTable for xml auto, elements
|