T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Write Query Dynamic Generated Column

  Hi All, I want to write a query on dynamic generated column. My table structure as below with some …

  shatrughna

  5 replies

  15 years, 5 months ago

  By: Alban Lijo

• I reduced my poor performing query from 10 min to 2 now if I could only use it

  Ok so I will try to keep a long story short yet provide the details. recently I was reveiwing some …

  Dan.Humphries

  15 replies

  15 years, 5 months ago

  By: Jim McLeod

• Insert Value in Identity Column

  How do I account for the value of an identity column when doing an insert to a table. A NOT NULL va…

  SQLEE

  3 replies

  15 years, 5 months ago

  By: SQLEE

• update openquery remote tabel with join

  Hi All, I have a problem with OPENQUERY update on remote table. I've googled for days, and can't so…

  abodor-1050556

  1 replies

  15 years, 5 months ago

  By: lightng

• Update using Query Analyzer difference

  I've an SP which updates few columns through an application. But there are chances that the admin g…

  SATISD9X

  1 replies

  15 years, 5 months ago

  By: Jim McLeod

• Different between CTE, Temp Table, and Variable Table

  Hi, I am new to SQL Server 2005, I came across this Temporary Table type CTE, Temp Table, and Varia…

  Akshay Shah

  2 replies

  15 years, 5 months ago

  By: ColdCoffee

• Conversion failed when converting datetime from character string - Error....

  I'm getting really yanked about this...this worked at one time but returns the following error... "…

  DP-721271

  4 replies

  15 years, 5 months ago

  By: Rob Schripsema

• incremental data loading

  My company has a process that runs every 30 minutes or so. This process loads data into the databas…

  ninel

  4 replies

  15 years, 5 months ago

  By: Mike01

• query each table in list of table names

  /* I have been tasked to query all tables in a database which contain a specific column and delete …

  crossmj

  7 replies

  15 years, 5 months ago

  By: WayneS

• Linked server limitation?

  Hi Does the usage of linked server have any limitation? For eg, on insert,delete,update to the link…

  xzd000

  4 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Trigger on delete of ANY table of Database?

  Hi I know its possible to prevent the execution of deletion command for certain tables by adding a …

  xzd000

  11 replies

  15 years, 5 months ago

  By: spaghettidba

• Alter Table - Find who altered it and when

  Hi, To know the last datetime when the table altered, we use select name,create_date,modify_date fr…

  Santhoshkumar KB

  5 replies

  15 years, 5 months ago

  By: Atif-ullah Sheikh

• My XML procedure is so slo-o-o-o-w

  I have the procedure below reading an XML file, then manipulating it to get the two columns I want,…

  rightfield

  3 replies

  15 years, 5 months ago

  By: rightfield

• Error Converting Data type varchar to numeric

  hi guys, im a newbie in this forum and im glad being a part of this programmer's den. anyways, im n…

  codewatcher11

  7 replies

  15 years, 5 months ago

  By: shailesh-360831

• Combining SELECT query, JOIN table with SUBSTRING

  Dear All, I want to display data USER LOGIN INFORMATION and ACCESS TYPE from 3 table: A. Table TblP…

  phina_el

  3 replies

  15 years, 5 months ago

  By: Lowell