SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Why SQL Server converts '' to zero

  I have a web developer who sent me a query he couldn't figure out. Select Name from dbo.Employee w…

  patrickbrewer

  3 replies

  12 years, 2 months ago

  By: Alan Burstein

• SQL Distinct comma delimited list

  Hi I am trying to create a comma delimted list of names in a table using the below query DECLARE @l…

  Simon Parry

  16 replies

  12 years, 2 months ago

  By: Alan Burstein

• sys.sql_modules.definition IS NULL for non encrypted views in some of our databases

  Hi everyone, we are using SQL Server 2012 Enterprise Edition since approx. 2 months. We recently no…

  Carl B.

  2 replies

  12 years, 2 months ago

  By: Carl B.

• Regarding sql server 2012 identity number gap problem after restarting sql server 2012

  Hi friends, I've a problem in sql server 2012, like i've one table, table name is "tblA". In that I…

  pksutha

  4 replies

  12 years, 2 months ago

  By: Erland Sommarskog

• SYSTEM_USER vs USER_ID(SYSTEM_USER) as default values

  Dear, I have a huge database with millions of rows all containing SYSTEM_USER value. The column val…

  aleksandar.ivanovski

  1 replies

  12 years, 2 months ago

  By: Erland Sommarskog

• Generate XML from SQL

  I am fairly new to XML and have been doing some research. I need to be able to create the following…

  system243trd

  7 replies

  12 years, 2 months ago

  By: SwePeso

• Rows for last week

  Hi Im trying to return all rows based on the query below and have used the dateadd(datediff timesta…

  szonkie

  5 replies

  12 years, 2 months ago

  By: Dwain Camps

• CPU Usage by current user

  Hi, How to find out Monitors % of CPU usage by the user using T-SQL

  christo83

  1 replies

  12 years, 2 months ago

  By: bhavi.buddi

• Cross Server Query (2012 and 2005) and Null Evaluation - NULL not recognized

  On a query running from SQL 2012, reading a view on a 2005 server, I am unable to figure out how to…

  Sarah Johnston

  9 replies

  12 years, 2 months ago

  By: Erland Sommarskog

• Is this syntax guaranteed to continue working?

  Hi all Pleas check out the code bellow: declare @tbl table (i int) declare @i int insert into @tbl…

  Adi Cohn-120898

  10 replies

  12 years, 2 months ago

  By: Adi Cohn-120898

• TOP 1 for each employee

  I need to select last order for each employees for homework I use northwind database for testing I …

  zombieisdead2020

  3 replies

  12 years, 2 months ago

  By: Luis Cazares

• OPENROWSET or OPENDATASOURCE - Situation preferences / Performance differences?

  Hi, I'm not asking what the difference between them is, because I think I get it after some time sp…

  sqldriver

  1 replies

  12 years, 2 months ago

  By: sqldriver

• DMV to replicate DBCC OPENTRAN - Log won't truncate

  I'm fighting with a very naughty leading application that likes to open transactions and orphan the…

  jallmond

  8 replies

  12 years, 2 months ago

  By: jallmond

• need sqlserver query to give similar output like dec command in sqlserver

  Hi, I need sqlserver query to give output like DESC TABLE_NAME command in oracle. I know sp_help 't…

  toravi.pentaho

  1 replies

  12 years, 2 months ago

  By: ChrisM@Work

• How to get correct datatype names for numeric and date type values

  Hi, When i try the below sql.I'm getting proper result for Varchar datatype field columns,BUT FOR N…

  toravi.pentaho

  3 replies

  12 years, 2 months ago

  By: HanShi