T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Deadlock Issue

  I have been looking into deadlock issue. While doing so, was able to track the following spids from…

  sqlnaive

  6 replies

  13 years, 5 months ago

  By: sqlnaive

• stroe speaical character in table

  hi i would like to store values like mg/1, mg/15ml etc. will nvarchar(50) will work,when i am using…

  harri.reddy

  2 replies

  13 years, 5 months ago

  By: Bhuvnesh

• OPENROWSET and Microsoft.ACE.OLEDB.12.0 ERROR

  Hi all, Hope you all are doing fine... (unlike me..).. I am trying to run the following query SELE…

  Deepak.Sharma507

  16 replies

  13 years, 5 months ago

  By: Dwain Camps

• Must declare the scalar variable when running script

  I am getting errors when trying to run an update script. the errors are Msg 137, Level 15, State 2,…

  nmcgowan

  11 replies

  13 years, 5 months ago

  By: Sean Lange

• WHERE condition..

  I have to update records in a table and there is no unique column on basis of whci I can put join U…

  kapil_kk

  22 replies

  13 years, 5 months ago

  By: kapil190588

• Calling function on select statement

  select col1, col2, col3, dbo.fun1(col1,col2) from tb1 function returns a string value with comma s…

  muthukrishnan.e

  9 replies

  13 years, 5 months ago

  By: ChrisM@Work

• In case of multiple matches for a key in a join , which value is updated ?

  HI All Below is the scenario : create table #test2 (j int,i int ,k char(1) ) create table #test3 (…

  koustav_1982

  2 replies

  13 years, 5 months ago

  By: Gail Shaw

• Add Minute

  Hi, I've got quite an unusual question. I'm running this simple query: SELECT SourceHub, Snap…

  kapil_kk

  6 replies

  13 years, 5 months ago

  By: Jeff Moden

• Query SQL version across estate

  Hi - I am wanting to query the SERVERPROPERTY of all out SQL servers and put the information in a t…

  Kwisatz78

  1 replies

  13 years, 5 months ago

  By: Steve Jones - SSC Editor

• Foreign Key Question

  If I have a table T1 with colA, ColB, ColC combined as primary key and another table T2 onant to de…

  sqlnaive

  11 replies

  13 years, 5 months ago

  By: sqlnaive

• Sending Mail

  How to send a mail through Storedprocedures with out using system stored procedures _______________…

  kapil_kk

  3 replies

  13 years, 5 months ago

  By: Lowell

• Change Data Capture 2008

  I have enable the change data capture on db and enabled one table and i made updates on couple of r…

  Mvs2k11

  4 replies

  13 years, 5 months ago

  By: Jason-299789

• char(??) vs varchar(??)

  Hi all. I have a database with over 200 tables. They all use char(xx) instead of varchar(xx). I…

  mike 57299

  10 replies

  13 years, 5 months ago

  By: kapil_kk

• Some way to write an INNER JOIN, but joining on either of two columns

  Hi, Each doctor in my doctors table has a main zip code and an alternate zip code. SELECT D.* FROM …

  matt6749

  8 replies

  13 years, 5 months ago

  By: matt6749

• Getting Year-Over-Year growth data

  I've a SQL query that returns the TotalMemberCount for the past 5 years on a yearly basis. Now I w…

  sql5322

  3 replies

  13 years, 5 months ago

  By: Dwain Camps