Topics
Started by
Posts
Last post
Hi, I am trying to learn how to use T-SQL to format an HTML table and email it to me. I've seen lo…
2 replies
Never Used this Command before need to Concat my last two Fields in my select and it is giving me a…
1 replies
We know that a statement like 'SELECT f1, f2, f3 INTO #temp FROM Table1' will create a temp table c…
10 replies
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
Viewing 15 topics - 751 through 765 (of 10,635 total)
You must be logged in to create new topics.