SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• monitor data changes

  How do you return all the data changes made to a table (inserts, updates, deletes) the past 2 weeks…

  MinhL7

  2 replies

  7 years, 12 months ago

  By: Paulo de Jesus

• Search with Date Range

  Hello, I have create table #test_table ([Date] datetime, [KW] nvarchar(255),[PP] float, [PM] nvarch…

  VegasL

  12 replies

  8 years ago

  By: HappyGeek

• Better TSQL Performance

  Hi everyone,  I am trying to improve query performance, I have encapsulated the following quer…

  PrettyMegaDBA

  18 replies

  8 years ago

  By: Jeff Moden

• Add New Column Based on Criteria

  Hello,  I have: select *from #test_table INSERT INTO #test_table ([Date], [KW], [PP], [PM], […

  VegasL

  7 replies

  8 years ago

  By: Jeff Moden

• Statistics for crud operation

  Hello guys, how can i get statistic for 2,3 days which operation like insert select update is used …

  iseedeadpeople

  3 replies

  8 years ago

  By: Jeff Moden

• How to chnage the data display format column to row

  I have data in below format and would like to generate in attached format Declare @TowerSDGoup as t…

  vijay_uitrgpv

  4 replies

  8 years ago

  By: vijay_uitrgpv

• Trigger table read?

  Is there a trigger that is activated when a table/row is read?

  jayg359

  11 replies

  8 years ago

  By: Jeff Moden

• Create a white space column in SQL 2012

  Hello,I am working on a project that requires I insert white space columns in a file that will be e…

  Barbara Ollivier

  10 replies

  8 years ago

  By: Phil Parkin

• VIEWs and execution plans

  I need to know what, if anything, can be done to avoid having SQL Server make use of an existing vi…

  sgmunson

  2 replies

  8 years ago

  By: sgmunson

• SSRS : Order the appearance on the chart according to the values of one of the fields

  Dear all, I am creating a new SSRS report. This report as a chart. Chart dispalys execution time a…

  river1

  6 replies

  8 years ago

  By: Umer Akram

• Quck TSQL question with regards to sys.master_files

  Hi,I hope this is the correct forum place to ask this question but I am getting an odd error with a…

  ade-d

  4 replies

  8 years ago

  By: Lynn Pettis

• CASE statement and inner join giving duplicates

  Dear DBAs I am using a CTE to get terminal locations from one table and then joining this CTE with …

  hurricaneDBA

  13 replies

  8 years ago

  By: hurricaneDBA

• Need some help Inserting data into a table

  All, I have 26K records which I have to insert into a table. I have built a query using the Excel b…

  NewBornDBA2017

  2 replies

  8 years ago

  By: NewBornDBA2017

• Outputing table with headers using bcp fails

  I am trying to export some table to csv using bcp, I have to do it query-like so this has to be the…

  dejanbltamamovic

  2 replies

  8 years ago

  By: Sergiy

• Update query for 2 table

  Hi Alli have this Query Belowstring updateReq = "UPDATE Student SET Student.ID_Request = Request.ID…

  aminhitman0212

  4 replies

  8 years ago

  By: Sergiy