SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to Convert a Varchar value to INT

  Hi Experts, I am new to T-SQL development and here's what I am trying to do. declare @cmd varchar…

  Ashif Shaikh

  3 replies

  11 years, 8 months ago

  By: Gail Shaw

• Trying to Connect to SQLCMD for Some Reason Im unable to CONNECT to the SQL COMMAND.

  I Am Using a Windows 7 operating system with SQL SERVER 2012 , trying to restore the master databas…

  allamsanjeev

  7 replies

  11 years, 8 months ago

  By: Lowell

• What are DMV? Can some one teach me with examples.

  HI I want to find how to use DMV and when to use them?

  Port1433

  4 replies

  11 years, 8 months ago

  By: Grant Fritchey

• Need assistance with making a sproc SQL Injection proof

  Hey guys, its beena while since I've been on a team where there is a web app so I'm having to knoc…

  dndaughtery

  11 replies

  11 years, 8 months ago

  By: MarbryHardin

• t-sql 2012 with implicit join

  I am trying to understand how the following t-sql 2012 with an implicit join is currently executed:…

  wendy elizabeth

  2 replies

  11 years, 8 months ago

  By: Lynn Pettis

• Weekly Best Seller

  Hi there I have a table containing products sales by Year and Week. I would like to know how many t…

  Jako de Wet

  12 replies

  11 years, 8 months ago

  By: David Burrows

• Need Query Help

  I want to update table2 by checking table1. if trauma has atleast 1 then clm2 in table2 would be 1 …

  DBA12345

  2 replies

  11 years, 8 months ago

  By: Luis Cazares

• Normalize values from column split using tally table

  I have a table that has the following structure: EntryID int, Categories varchar(200) values look l…

  Raul Undreiner

  2 replies

  11 years, 8 months ago

  By: Lynn Pettis

• How to check column name in case sensitive?

  Hi Friends, I have a table called SrcReg which is having a column name called IsSortSeqNo smallint.…

  prakashr.r7

  8 replies

  11 years, 8 months ago

  By: prakashr.r7

• Replacing UNION in TSQL 2012

  Gents, I have been looking for the most optimal way to replace UNIONs all over the internet and I c…

  gaheinze

  4 replies

  11 years, 8 months ago

  By: LutzM

• Simple JOiN

  I have 3 Tables; User, UserType, Permissions - Common Field between User and UserType is UserTypeI…

  fgrubercpa

  2 replies

  11 years, 8 months ago

  By: LutzM

• Query Performance

  Hello, I have written this sample query to search a full-text indexed table and return the results.…

  mail4bartley

  2 replies

  11 years, 8 months ago

  By: J Livingston SQL

• Output of a table required in a specific format.

  Hi all, I need to display the output of a table in a specific format, I have attached the sample sc…

  T.Ashish

  2 replies

  11 years, 8 months ago

  By: J Livingston SQL

• Combining values into comma separated list - serialize

  Hi, I have a requirement for SSRS report where part of the input has the following structure: Store…

  vecerda

  2 replies

  11 years, 8 months ago

  By: a4apple

• Combining values into comma separated list - serialize

  Hi, I have a requirement for SSRS where the input has the following structure: Store NumberStore O…

  vecerda

  1 replies

  11 years, 8 months ago

  By: Sean Lange