Topics
Started by
Posts
Last post
Can you help me with this please... I wrote a query in ms sql n when i execute this it gives xml ou…
2 replies
Ok, so if you want to keep your sanity, it probably would be best not to ask why I need to do this …
5 replies
I have a query and I'm trying to loop through the results; however, I'm only getting 1 result, wher…
41 replies
I have a datecolumn in this format 2009-10-15 16:57:00 in a table. I need to write a query which ta…
6 replies
Declare @A money, @Picklist varchar(10) -- for testing SELECT @A = 1000, @Picklist = 'Exclude' --…
26 replies
Hi, When renaming a Table/Column using sp_rename we get below message Caution: Changing any part of…
1 replies
sp_fileexist does not seem to work on a mapped drive, or a network share. Anybody have any alternat…
9 replies
EXEC msdb.dbo.sp_send_dbmail @recipients = 'EMAIL REMOVED', @subject = 'Something I…
3 replies
Hi Say we have a script that is enclosed in a Transaction . If we run this on the server and encoun…
1 replies
I have this query: select * from loandata where loan in( 0023835689, 0023837701, 0023833726, 002383…
4 replies
Is there a built in procedure that lists indexes along with their include columns in SQL 2005? The …
1 replies
I have a table with millions of order lines The lines can be in one of 6 different status's I need …
4 replies
So I have to work on some stored procs for a development project. Basic CRUD stuff. I'm running in…
19 replies
Guys, I was playing around with some computed columns and noticed some weirdness. From my understan…
2 replies
Hi as iam new to T-sql plzz help me hw to write query suppose there are 10 records in a table i nee…
26 replies
Viewing 15 topics - 5,086 through 5,100 (of 12,234 total)
You must be logged in to create new topics.