Topics
Started by
Posts
Last post
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
Hi Please help I get a devide by zero error when I run this query, can someone please show me how t…
2 replies
I want to copy a table from SQL Server to linked server, have tried couple of ways but not working:…
2 replies
Hi , I have a case statement where i am checking for some dates and displaying a number for each da…
3 replies
Hi, I need a TSQL to search a string in a column. SUBString works but I should know the strarting p…
7 replies
Viewing 15 topics - 5,086 through 5,100 (of 12,230 total)
You must be logged in to create new topics.