T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Table variable does not take part in Transaction

  Hi, I am a bit confused about the table variables. As transaction does not affect the table variab…

  AJ07

  19 replies

  15 years ago

  By: AJ07

• BULK INSERT multiple files without xp_cmdshell

  Hi all, Is there a way to bulk insert multiple files from a shared folder into a table without usin…

  e90fleet

  6 replies

  15 years ago

  By: Orlando Colamatteo

• Discovering Foreign Key Constraints

  I have a denormalized table that provides code values for various lookups. I am doing a proof of c…

  Brandon Forest

  1 replies

  15 years ago

  By: Orlando Colamatteo

• Server Name column in Multiserver Results

  The Server Name column that is returned with multiserver queries (if the option is set to True), ca…

  GoofyKC

  7 replies

  15 years ago

  By: GSquared

• End date is less then Start Date

  Hi, I am facing some problem when I was populating the records in a table. i.e after populating th…

  kiran.rajenimbalkar

  5 replies

  15 years ago

  By: Jason-299789

• Better way of extracting the first 5 bits from bigint and convert them to int?

  Hi Guys I am just seeing how to improve this. I've got a bigint with some data inside, its first 5 …

  muten79

  3 replies

  15 years ago

  By: muten79

• SQL stored Procedures

  Hi All, Is there a way in creating stored procedure where you set parameters to accept multiple val…

  michael.martey

  12 replies

  15 years ago

  By: Evil Kraig F

• Where can I find study material on TSQL query tuning?

  Anyone know of a good book that includes query performance tuning?

  dndaughtery

  2 replies

  15 years ago

  By: Grant Fritchey

• Opinion: Three-part reference to local database?

  I'm working on improving best-practices and process at my current employer. Once of the consistent…

  Dan Colbert-387424

  4 replies

  15 years ago

  By: Jeffrey Williams

• While loop as a scheduled job fails

  I have the below script in a job, however, when it gets to a database that doesn't have the table (…

  lulu_lutz

  4 replies

  15 years ago

  By: David Benoit

• Unmatched Records query performance problems

  I think this should be an easy thing, but I am not really sure. Using SQL Server 2008r2, Core I7 95…

  philipdub

  7 replies

  15 years ago

  By: tfifield

• Delete duplicate rows

  Hi, i am trying to solve this issue without result. I want to display one record by Id from A. Let …

  Mosafi

  10 replies

  15 years ago

  By: Mosafi

• Help with echo in xp_cmdshell

  Declare @Footer varchar(1000) Set @Footer = 'echo RECORD COUNT: >> D:\Work\Test.txt' exec x…

  namrata.dhanawade-1143388

  4 replies

  15 years ago

  By: Orlando Colamatteo

• change datatype of a column in a table - generic script

  I need to write a generic script to change the datatype of any column in it. I want to pass table n…

  ekant_alone

  4 replies

  15 years ago

  By: Orlando Colamatteo

• Primary Key based on Function

  Hi All, I have a table with a PK of type bigint. Let's call the field "ID". The rule I have to f…

  Richard Warr

  4 replies

  15 years ago

  By: Richard Warr