SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Incorrect syntax near *

  DECLARE @TABNAME NVARCHAR(255)='dd', @LAST_CHECKED_DATE_TIME VARCHAR(100)=CONVERT(VARCHAR(20),get…

  @Patrick123

  12 replies

  9 years ago

  By: Lynn Pettis

• GET Counts for insert,update,delete

  CREATE PROCEDURE [dbo].[count] AS BEGIN DECLARE @TABNAME NVARCHAR(255), @TIME VARCHAR(100), …

  @Patrick123

  5 replies

  9 years ago

  By: Lynn Pettis

• delete all tables using sqlcmd

  Hi guys, Can someone please help me to convert below tsql script to sqlcmd? I need to connect to a …

  whitesql

  4 replies

  9 years ago

  By: Jeff Moden

• How combine Duplicate records with single

  Hi All, I am inserting data from customer table to fact_customer customer table has duplicate recor…

  Gaja

  5 replies

  9 years ago

  By: Chris Harshman

• calculate difference and percentage

  Hi, I have following data , numbers recruited/applied for a particular office, and would like to fi…

  sindhupavani123

  3 replies

  9 years ago

  By: sindhupavani123

• Restore database to a point in time (working a disaster recovery plan)

  Good day all, I am trying to work a disaster recovery plan. I want to restore a database to a point…

  Manie

  6 replies

  9 years ago

  By: Thom A

• Update duplicate keys

  So I have a stored proc INSERT INTO dbo.Table2 (Application, Timestamp, Performance, Availability) …

  Matt.Altman

  10 replies

  9 years ago

  By: Matt.Altman

• Replace uppercase words with bold

  I need to replace in given string all uppercase strings longer than two characters with lowercase a…

  dothedev

  16 replies

  9 years ago

  By: Luis Cazares

• Xevents and plan_handle

  Hi, i run Xevents to capture sqlserver.sp_statement_completed with sqlserver.plan_handle when i que…

  Mad-Dog

  1 replies

  9 years ago

  By: Grant Fritchey

• duration in extended event not working properly

  Hi, I've SQL 2012 SP2 and i trying to setup extended event for sqlserver.rpc_completed with duratio…

  Mad-Dog

  5 replies

  9 years ago

  By: Gail Shaw

• SQL Query

  col A colB Details A1ValueA Details1 A2ValueA Details2 B1ValueB Details1 B2ValueB Deta…

  mtz676

  6 replies

  9 years ago

  By: Eirikur Eiriksson

• advice on model

  hi, i would love some advice on how to best model this problem: i need to attribute grades to stude…

  a20213

  2 replies

  9 years ago

  By: a20213

• Need assistance with Dynamic SQL

  Hello, I have the following code below that is throwing the following error: Msg 214, Level 16, Sta…

  oradbguru

  7 replies

  9 years ago

  By: oradbguru

• DB Restore Error

  Can anyone please give some assistance, I keep getting Logical file 'LIVE_OPERATIONS_BA' is not par…

  cbrammer1219

  3 replies

  9 years ago

  By: Chris Harshman

• delete all table from a table

  Hi! I need to delete all tables listed in a table named dbo.tblSum. There are 500 tables that I nee…

  whitesql

  9 replies

  9 years ago

  By: Eirikur Eiriksson