T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• EXECuting a dynamic string

  I am urgently in need of some help. My colleague and I have developed a script (that works) but use…

  Darryl Wilson

  8 replies

  14 years, 1 months ago

  By: Sony Francis @EY

• Query XML

  I'm wanting to query an XML site, which is really just an RSS feed. I want to be able to put the d…

  jordon.shaw

  3 replies

  14 years, 1 months ago

  By: Orlando Colamatteo

• Need T-SQL for this requirment

  I have a table where it lists all the "ServerName", "DBName", "DBSize", "Date"...but this table has…

  SQLisAwe5oMe

  6 replies

  14 years, 1 months ago

  By: SQLisAwe5oMe

• passing information to sql trigger

  I have a trigger that will write out an audit trail record with the changed values to an audit file…

  johnr104

  5 replies

  14 years, 1 months ago

  By: mtassin

• Question about Index Usage

  Hi, I had been working on some code improvements for performance gains every now and then. I was go…

  chandan_jha18

  2 replies

  14 years, 1 months ago

  By: Gazareth

• use with dynamic sql

  I'm trying to do in a script: SET @DYNSQL = 'USE ' + @DBName + ' SELECT name AS [File Name] , phys…

  Sailor

  3 replies

  14 years, 1 months ago

  By: Sailor

• Triggers

  Hi all, I am new to sql server, How to write a trigger which stops the DML operation on a table for…

  maheshkrishnas

  16 replies

  14 years, 1 months ago

  By: Eugene Elutin

• Translate this PL/SQL code into T-SQL for SQL Server.

  Dear All, Its is very urgent , I am new to PL/SQL. Kindly help me to translate this PL/SQL code int…

  reluc23

  5 replies

  14 years, 1 months ago

  By: reluc23

• SSMS stops while showing query execution plan

  hi when i am showing estimate execution plan,SSMS just stops working. what causes it to stop workin…

  riya_dave

  6 replies

  14 years, 1 months ago

  By: Eugene Elutin

• Like query from another table

  Hi, I have a table Account with two columns Ac_no and code_list. Ac_no Code_list 12345ab…

  Dhruvesh Shah

  7 replies

  14 years, 1 months ago

  By: Dhruvesh Shah

• Optimize select query

  SELECT drm.requestid, DRM.RunningBoard,DRM.DutyBoard,DRM.DriverId,DRM.PublicServiceCode,DRM.Service…

  hmsanghavi

  12 replies

  14 years, 1 months ago

  By: MVDBA (Mike Vessey)

• SQL Copy only newest files

  Hi All, I have a question that i hope SQL can do because I can't find anything on the net at all. I…

  Tava

  1 replies

  14 years, 1 months ago

  By: Tava

• Conditional select with function

  I need to select some data based on a weight and a unit of measure. However, the unit of measure wi…

  Rog Saber

  7 replies

  14 years, 1 months ago

  By: vinu512

• insert statement with variable for column name

  Is it possible to do something like this? I'm getting an invalid column name on the column variable…

  ReginaR1975

  4 replies

  14 years, 1 months ago

  By: ReginaR1975

• Update record if exists else create new

  Hi, I have two tables say 'A' and 'B' and then have 'ID' field common in them. I want to write an S…

  Deepz

  9 replies

  14 years, 1 months ago

  By: Deepz