Topics
Started by
Posts
Last post
Hi I am using msdb.dbo.sp_send_dbmail and the property @attach_query_result_as_file=1; It works wel…
1 replies
I have the following update statement : Update consultant.consultant SET SponsorXID = a.XID FROM[c…
5 replies
the lead programmer slammed in a set of new database updates by scripting the entire set of stored …
5 replies
I need to retrive the integer part from a varchar filed. A varchar filed contains SATHIK01,SATHIK10…
12 replies
sum(isnull('Premium' + cast(@i as varchar),0)) There are fields in the table - 'Premium1', 'Premium…
4 replies
/* I have an Import process. I am working with two tables, tblImportConfig and ImportHistory. In ad…
2 replies
I am in a need to create a dynamic sql . But in this script column values contains apostrophes ( ' …
2 replies
HI... I have a simple example: table 1 id int -> primary key table2 id int -> foreign key of …
4 replies
I have one table declare @temp table (col1 varchar(300), col2 varchar(300)) INSERT INTO @temp VALue…
2 replies
Hi all, I just come across the .Write clause. Was wondering about some execution plan differences w…
4 replies
Hi I need to create xml files (to disc) by querying a SQL Server 2005 table. What is the best way t…
5 replies
Hi I have a table as follows ID ParentID Amount 5 …
1 replies
what is the main difference between In and Exist?
1 replies
I am doing some data conversion and am trying to clean up some data. I have a problem with a comm…
2 replies
Hello guys, I m gonna create a generic stored proc. for update. I think I should use dynamic query.…
3 replies
Viewing 15 topics - 9,511 through 9,525 (of 12,230 total)
You must be logged in to create new topics.