Topics
Started by
Posts
Last post
When we insert/update a string that is bigger than the size of the column we get following error&nb…
2 replies
Has anyone had experience using the query hint.. " option (KEEPFIXED PLAN) " ? If so, h…
1 replies
Hi, very interesting thing if i have field float number 99 is in database present 98.99999999999999…
2 replies
Hello all, I have a DTS package that runs on Saturdays and want to come up with a way to determine …
7 replies
EXEC master..xp_cmdshell 'osql -U______ -P______ -Q"select * from MyTable" -dAutoMail -h-1 .s…
1 replies
Let's say I have the following value clause in an insert statement: "Column1" = (SELECT CASE WHEN …
2 replies
Hi Can someone tell me how to error trpa whic specific record/records that generates primary…
5 replies
I am trying to test setting Transaction Isolation levels on our dev server which is sql7. I have an…
1 replies
I tried to search for this but I had a hard time finding anything. The word "use" tends to re…
4 replies
Hi, I am new to SQL Server and I need some help in setting up work week DAY function. I am working …
2 replies
Is it possible, in a stored procedure, to FTP the results of a query? I know how to do it if …
1 replies
I want in a log function to be able to read the set rowcount nnn variable. Has anyone an idea …
3 replies
I have a cursor that goes thorugh a table and updates a Date table. Except that I need to increase …
10 replies
I'm trying to set a variable equal to a string based on a combination of criteria. For example: If …
4 replies
Hi, I have a table A which is having the following data BirthDate 12/1/2005 12/20/2005 1…
17 replies
Viewing 15 topics - 8,326 through 8,340 (of 17,082 total)
You must be logged in to create new topics.