Topics
Started by
Posts
Last post
how can i compare two tables in two different databases within the same server.
13 replies
Dear Team, I have a Table "TokenHdr" in which combination of "LocId" & "RowId" is forming a PK…
7 replies
Almost silly question that I'm curious about. Can I drop a local temp table owned by myself in anot…
7 replies
Hi All, Can some one provide DDL Trigger script to Prevent Sysadmin Roles. Regards, Shenkar Gade
2 replies
At my work site occasionally the nightly process that refreshes a SQL database from the main (SAP) …
9 replies
--This is what I am trying to create PROD_CODECODE 1CODE 2CODE 3 -------------------------------…
3 replies
I have these 3 tables to work with. #Master_Products and the #Shipping_Codes have a one to many rel…
2 replies
pseudo code: create function udf1 ( @one int, @two int) as --- test this udf: select * from udf1(…
6 replies
How can I return select @@servername along with the result of this stored procedure - msdb.dbo.sp_g…
13 replies
Hi Friends, I had an interview and i was asked the below scenario.. I gave him the answer with Cros…
4 replies
Hello Gurus, I have a case where instead of looking too much into the indexes(Tables are not that b…
16 replies
HI I am using date add Query for following method update OfflineExamScheduleMaster set edatetime=d…
2 replies
Hi, I have inherited a report from a old colleague and you can see that he has used the FOR XML Pat…
4 replies
Hi, I have been out of the MSSQL world for about 5 years so trying to catch up. I found this wonder…
10 replies
Hi No doubt this is standard behaviour I should already know about, but I'm a little unclear about …
15 replies
Viewing 15 topics - 751 through 765 (of 10,647 total)
You must be logged in to create new topics.