SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Any benefit in a covering non-clustered index on clustered index columns?

  I have many lookup tables - parent table has a ChildID and JOINs the Child Table to get a column co…

  Kristen-173977

  2 replies

  10 years, 5 months ago

  By: Kristen-173977

• t-sql 2012 update statement truncates varchar value

  In t-sql 2012, data is obtained from [Inputtb].lockCombo1 where it is defined as varchar(8). The da…

  wendy elizabeth

  3 replies

  10 years, 5 months ago

  By: ChrisM@Work

• Add Columns to Result that Don't Exist in Table?

  I am trying to produce a query result that will be using a Case statement to determine values based…

  SilhouetteBS

  6 replies

  10 years, 5 months ago

  By: Jason Selburg

• t-sql 2012 insert not working on merge statement

  In a t-sql 2012 merge statement that is listed below, the insert statement on the merge statement l…

  wendy elizabeth

  6 replies

  10 years, 5 months ago

  By: Jeff Moden

• Help Replacing String

  Hi Folks, I'm trying to replace a particular part of a row in a table with a new value. The row is…

  jhutchings

  2 replies

  10 years, 5 months ago

  By: jhutchings

• what's wrong with my insert with cte?

  INSERT INTO Lookup ( LookupTypeID, LookupReference, Description, OtherReference, …

  TSQL Tryer

  3 replies

  10 years, 5 months ago

  By: TSQL Tryer

• Build search condition dynamic

  /*-------------------------Drop temp tables-------------------------------------------*/IF OBJECT_…

  mxy

  7 replies

  10 years, 5 months ago

  By: Sean Lange

• Variable with <> or =

  Hello, who can I use a variable like the followig set @MAG3 = '<> 0' or set @MAG3 = '= 0' for…

  orenk

  4 replies

  10 years, 5 months ago

  By: orenk

• Slow Query (FOR XML)

  Hello Experts I am going to start by explaining my set up. Hardware: SQL Server 2012 Standard Edit…

  sandhuz24

  8 replies

  10 years, 5 months ago

  By: Eirikur Eiriksson

• Getting problem in comparison

  Hi, Could you please help to sort out comparison problem DECLARE @TIMESTAMP varchar(30)='EventTime…

  sushil_dwid

  1 replies

  10 years, 5 months ago

  By: sushil_dwid

• Varchar Vs NVarchar

  i have a table with below columns / datatypes col1 varchar10 col1 varchar30 col1 varchar100 col1…

  Minnu

  1 replies

  10 years, 5 months ago

  By: Gail Shaw

• Determine Read/Write Frequency

  How do I determine the read/write frequency on a database table? I am trying to do this on a 2012 a…

  mceventphoto

  2 replies

  10 years, 5 months ago

  By: mceventphoto

• Assign value to variable

  Can you please help to make it workable code.. declare @i int=1 declare @numweek int=2 declare @a …

  sushil_dwid

  7 replies

  10 years, 5 months ago

  By: sushil_dwid

• Query on grouping data on weekly basis

  Hi , I have query on grouping data on weekly basis.. 1. Week should start from Monday to Sunday 2…

  sushil_dwid

  1 replies

  10 years, 5 months ago

  By: ChrisM@Work

• Conditional Join between two tables

  Hi SQL Folks, I have two tables tabA (cola1, cola2, cola3) and tabB(colb1, colb2, colb3, colb4) whi…

  syedathariqbal

  7 replies

  10 years, 5 months ago

  By: syedathariqbal