SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Creating Integer Primary key value using the following query

  Discuss the following sql query with respect to performance in an applicaiton involving more number…

  carriet

  18 replies

  11 years, 6 months ago

  By: carriet

• Password on SP

  Hi guys, Just wondering, is it possible to create PW on Stored Procedure? No one can execute or Al…

  rocky_498

  1 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• help with filtering criteria/ make it sargable

  My current sql uses the YEAR function to get the YEAR portion of a data column. I read an article i…

  itortu

  6 replies

  11 years, 6 months ago

  By: itortu

• modifying date range

  Hello, I would like to ask for help changing the date range to be -1 year from today until today T…

  itortu

  2 replies

  11 years, 6 months ago

  By: itortu

• SSIS Package worked and then stopped

  I create a package that has a foreach loop container, inside the FE container the is a dataflow, sc…

  cbrammer1219

  4 replies

  11 years, 6 months ago

  By: cbrammer1219

• Converting datetime to bigint: Native formats: reverse engineering.

  Hi. I have a table containing a timestamp stored as a bigint. The database has a UDF which convert…

  thepotplants

  4 replies

  11 years, 6 months ago

  By: thepotplants

• What enhancements have been to the 2012 GUI that facilitates faster coding, etc.

  What enhancements have been to the 2012 GUI (Client only) that facilitates faster coding, etc.? I a…

  Welsh Corgi

  11 replies

  11 years, 6 months ago

  By: Robert Klimes

• Assigning numbers for a range during an INSERT

  Given a Table1 with two columns 'Name' with some N rows of data and another Table2 with one column …

  rray 44280

  3 replies

  11 years, 6 months ago

  By: rray 44280

• Help\Advice on building a query

  Hi I am trying to build a query which will be used in an automated report to calculate failure rate…

  centerman99

  8 replies

  11 years, 6 months ago

  By: centerman99

• query to return all proc calls in order for timerange

  I have a query using the sys.dm_exec_query_stats that returns the last exec of all proc calss for t…

  Snargables

  1 replies

  11 years, 6 months ago

  By: TheSQLGuru

• On-Premises SQL Server Integration with Azure Application

  We have an application (called Umbraco) hosted on Azure. We also have an on-premises SQL Server da…

  heb1014

  3 replies

  11 years, 6 months ago

  By: Grant Fritchey

• how to update one column value to another in same table

  my table payment_details structure is payment_id payment_code 1 null 2 …

  neethu payal

  3 replies

  11 years, 6 months ago

  By: shubham.saxena67

• need to select a column with the repalcement of '0'

  i have a table like below create table #temp ( valid_id int not null, valid_no varchar(50) ) 10001…

  deepu chan

  7 replies

  11 years, 6 months ago

  By: ScottPletcher

• Local SSIS Package runs and exports data excepts in job

  Using server 2012 on local machine, I created an SSIS package that will execute in integrated servi…

  a_firstenberger

  1 replies

  11 years, 6 months ago

  By: Koen Verbeeck

• Input paramter for Store Procedure like in statement 'Value1','Value2'

  Hi all, How can I input parameter for Store Procedure like In ('Value1','Value2') Example : Create …

  cuong.dangvinh

  6 replies

  11 years, 6 months ago

  By: Luis Cazares