Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Why don't bulk imports TABLOCK by default?

  I've been reading about the "table lock on bulk load" option and TABLOCK hint. So my understanding …

  codykonior

  1 replies

  11 years, 2 months ago

  By: Grant Fritchey

• suggestions on one to may relationship in the data processing

  Hi all, I need your suggestion on below program development I have a scenario where one partner can…

  Gangadhara MS

  15 replies

  11 years, 2 months ago

  By: Greg Edwards-268690

• Recursive family, but how?

  Hi, I have a family table and would like to group all related members under the same familyID. Thi…

  SeeknFind

  3 replies

  11 years, 2 months ago

  By: SeeknFind

• DBCC FreeProcCache

  Hello, My knowledge of SQL is very limited. One of our old co-workers ran DBCC FreeProcCache on ou…

  sumeetahluwalia

  4 replies

  11 years, 2 months ago

  By: sumeetahluwalia

• How to: Bulk import xml to table

  Anyone has any suggestions? ^^ I found loads of things but nothing seems to work... I'm trying to g…

  pk2dpvp

  9 replies

  11 years, 2 months ago

  By: pk2dpvp

• view to physical table options

  Hi, I have a view which select some few columns from multiple tables with where clause and have 5 …

  Gangadhara MS

  2 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Transaction rollback when multiple threads are inserting records into table because of trigger

  Hi All , I have two tables called ECASE and PROJECT In the ECASE table there is trigger to get the …

  ravi.teja 62048

  3 replies

  11 years, 3 months ago

  By: Gail Shaw

• xp_cmdshell in stored procedure not the same result as cmd prompt

  I have a stored procedure that uses xp_cmdshell to execute an executable. I made code changes to t…

  dirk.dromgoole

  6 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson

• CASE condition not affecting CAST output

  Hi, I've a variable in my SP that I'd like to use to change the format of my output. Try this! sele…

  greg.bull

  8 replies

  11 years, 3 months ago

  By: mister.magoo

• check if changed

  okay so I'm pretty new to sql server and now I need to create a script that: compares the values of…

  pk2dpvp

  2 replies

  11 years, 3 months ago

  By: Orlando Colamatteo

• Row count condition check

  Hi, I have the following code to send out an email if the row count of a table exceeds a certain nu…

  mickeytech2000

  5 replies

  11 years, 3 months ago

  By: Sean Lange

• update row always has results but still doesn't work

  I have this script in my database, but it always gives 2054 rows back and if I actually DO change …

  pk2dpvp

  30 replies

  11 years, 3 months ago

  By: Jason Wolfkill

• How to get a pivot statement without aggregate

  Hi I want to pivot a table something like this . I pivotted it succesfully but the results are not …

  1246.sravanthi

  2 replies

  11 years, 3 months ago

  By: jagank

• Problem with generating XML in MS SQL

  Hi All, I m facing a prblm in generating the XML. Please help me guys. My Current Output : <Ro…

  subbubally

  5 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson

• insert join set where

  I tried to make an insert query that adds all the values of a dummy table which are not yet in the …

  pk2dpvp

  3 replies

  11 years, 3 months ago

  By: Koen Verbeeck