T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• T-SQL to generate create table script?

  I know there have to be at least a few out there... Does anyone have a T-SQL script to generate the…

  Pam Brisjar

  15 replies

  17 years ago

  By: Jeffrey Williams

• inserting multiple records and assigning a sequential value

  I want to insert a whole chunk of records at one time, based on some data being pulled from another…

  M Jones

  2 replies

  17 years ago

  By: Lamprey13

• DTS - SQL 2000

  Hi, how can I create a query that is always looking for if a table exists or not, by a DTS

  rafael_113

  4 replies

  17 years ago

  By: Sean Lange

• values separation

  hi I have table like ID NAME --- ------ 1 aaa 1 bbb 1 ccc 1 …

  venki_1276

  4 replies

  17 years ago

  By: OTF

• query link server instance

  I am trying to teach myself SQL Server, MS Press book shows how to create a linked server, but neve…

  Jesse-613268

  5 replies

  17 years ago

  By: lfguzman_25

• How to concatenate row values?

  I am looking for suggestions/ideas to concatenate row values without using a cursor or CLR. Basical…

  MissyDaisy

  8 replies

  17 years ago

  By: GSquared

• how to insert deafult values dynamically for null fields

  hi I want a sql query for a stored procedure that take 2 input paramters (image,and varbinary) and …

  waleed_m_M

  7 replies

  17 years ago

  By: Florian Reischl

• Retreive records without cursor

  I have a table employees with fields empno (PK), name, office. Another table postings with fields s…

  Atif

  20 replies

  17 years ago

  By: ps.

• Optimized and fast query for simple join?

  Hi i have two tables, TABLE1 SIDSNAME 1SAM 2RIG 3MAT TABLE2 DATEIDPRICE 1/1/1113 1/2/1214…

  descentflower

  5 replies

  17 years ago

  By: Florian Reischl

• Search All

  Hi, I need to search a keyword from all databases using sql query or procedure. (Ex: Suppose if i …

  manikandan-1115962

  3 replies

  17 years ago

  By: Florian Reischl

• Verification of Query

  Scenario: table called EmailAddresses and the columns ID (int) and EmailAddress (varchar(100)) Que…

  john-1115910

  3 replies

  17 years ago

  By: ps.

• Using @@IDENTITY With OUPUT Clause

  I am using @@IDENTITY to determine the ID of the last inserted value in a table (Table1). I use th…

  southwynd

  5 replies

  17 years ago

  By: Jeff Moden

• average rows between last match

  Lets say I have a "date" column (PK one row per day) and a "item" column (1 of 10 different items …

  ac2

  7 replies

  17 years ago

  By: Jeff Moden

• Locking Perf Problem: Help Update/Insert WITH table_hints

  System: I have 50 jobs recurring every 10 seconds to concurrently update a 5000 row table called Cu…

  Aaron-237544

  44 replies

  17 years ago

  By: Paul White

• Need help with a Query..

  Hi Friends, I need some help with a query. I have a table Test that stores the marks of students. …

  Vinu verma

  1 replies

  17 years ago

  By: GSquared