Topics
Started by
Posts
Last post
Hello Experts WAs trying to explore about Plan Guides. Created few plan guides (taken from MSDN), b…
1 replies
Im writing a query and I have to use "?" as parameters. "?" will represent two things. StartDate pa…
6 replies
Is there a way to remove a table-type variable when you're done with it? I have a large procedure t…
5 replies
Hi, I have a full backup every night , differential backups every 2 hours and trans log shipping. S…
2 replies
I am looking for a query where in I can have a conditional statement within inner join after ON sta…
1 replies
All my textbooks start at error 50000, so I'll try here... I need to develop code for a TRY...CATCH…
1 replies
Hi All, In My SP Msg 7405, Level 16, State 1, Procedure usp_Batch_STDAllFields_MCPHD_Merge, Line 64…
1 replies
hi, I'm having a problem with a insert as select to a table in a linked server, the command is ins…
2 replies
Merge two rows into one (conditions or Pivot?) I have Temptable showing as Columns:EmpName, Code, B…
3 replies
Hi, I want to know can we write a script to transfer data from MSSQL to Mysql. I need to build a SQ…
8 replies
I am using SSMS 2008 R2, and I cannot connect to a sql compact database. When I try, I get the fol…
1 replies
Does including non-key columns help much in the performance of an index?
8 replies
Hi beautiful people, Following code is okey. SELECT CODE, NAME, [FORUM AYDIN]=ISNULL((SELECT ONHA…
18 replies
The keyword AS normally creates a column name for an alias. Can someone please tell me how to do th…
12 replies
Hi, I have just been running a query which I was planning on improving by removing a redundant GRO…
2 replies
Viewing 15 topics - 3,706 through 3,720 (of 30,225 total)
You must be logged in to create new topics.