SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• INSERT INTO Issue in SQL 2012

  I have a query that executed OK in SQL 2008. INSERT INTO @Authors (AuthorName) SELECT AuthorName f…

  michaelh-731356

  17 replies

  12 years, 9 months ago

  By: Paul White

• Does Not Allow Multiple Updates Using A Sub Query

  Good Morning Guys, i wanted to ask you guys on your 2 cents on this. i was trying to run an Update …

  Stylez

  6 replies

  12 years, 9 months ago

  By: Lynn Pettis

• Exiting sqlcmd with RAISERROR(50001,10,127)

  I am trying to set up some upgrade scripts using sqlcmd but I need a graceful exit from the script …

  Michael Lato

  7 replies

  12 years, 10 months ago

  By: Orlando Colamatteo

• which is the correct way to delete multiple jobs in sql server

  Im using SQL Server 2012 and I have a case where I have to delete sql jobs. I found two approaches …

  sriharsha2410

  1 replies

  12 years, 10 months ago

  By: Orlando Colamatteo

• Single Sum, not cumulative sum

  Hi, I have these tables; Regns, PJs, Smps and His CREATE TABLE Regns ( sn INT NOT NULL …

  oolawole

  10 replies

  12 years, 10 months ago

  By: Sean Lange

• View

  Hi, How do I represent a view to post on in a topic?

  oolawole

  5 replies

  12 years, 10 months ago

  By: Sean Lange

• Pivot Table

  CREATE TABLE [dbo].[TableTemp]( [BASEL_CATEGORY] [varchar](50) NULL, [EC_DRAWN] [numeric](18, 6) …

  greeshma.patla

  1 replies

  12 years, 10 months ago

  By: Gail Shaw

• SQL Server 2012 not accepting string data starting with numbers

  I've been wracking my brain over this one and it is slowly sending me into a spiral of madness... I…

  CXSConsulting

  4 replies

  12 years, 11 months ago

  By: CXSConsulting

• Maintenance plan with powershell

  Hi, I'm quite new on this forum but it's really a great place. I have a question for some great exp…

  matthieu178

  11 replies

  12 years, 11 months ago

  By: matthieu178

• Find lottery winner

  Hi all, I have table that contains lottery data : CREATE TABLE dbo.tblLottery ( customerI…

  farax_x

  9 replies

  12 years, 11 months ago

  By: farax_x

• Calling Throw within If block

  Hi All, I thought I'd try using throw instead of raiseerror in my application, to try to remove the…

  Eugene-928407

  5 replies

  13 years ago

  By: seth delconte

• MSSQL 2012 versus 2008...2000

  I have been using the following syntax in prior versions and it worked, however when I try it in 20…

  roy.tollison

  7 replies

  13 years ago

  By: Orlando Colamatteo

• T-SQL Help

  I have a as/40o file that I need to import into my SQL server, but this file has 123 rows and its u…

  Maique

  3 replies

  13 years ago

  By: Maique

• Change sequence schema

  Hi all, I have some sequences and I want to change their schmas. How can I perform this action with…

  farax_x

  1 replies

  13 years ago

  By: farax_x

• Assistance For Script

  Hi What I am trying to do is do a calculation based on the previous records calculated value. What…

  ljmack00

  4 replies

  13 years ago

  By: ljmack00