I have a package deployed on SSISDB (the new concept in MS SQL 2012, SSIS catalogs). I have t-…
7 years, 9 months ago
I am trying to change a sproc that I have been using for years to do some DBCC CheckDB maintenance …
Is distributed queries with xml (data type) supported in SQL Server 2012? It is neither in 2005 nor…
By: Orlando Colamatteo
I have a query that executed OK in SQL 2008.
INSERT INTO @Authors (AuthorName)
By: Paul White
Good Morning Guys,
i wanted to ask you guys on your 2 cents on this. i was trying to run an Update …
By: Lynn Pettis
I am trying to set up some upgrade scripts using sqlcmd but I need a graceful exit from the script …
7 years, 10 months ago
Im using SQL Server 2012 and I have a case where I have to delete sql jobs. I found two approaches …
I have these tables; Regns, PJs, Smps and His
CREATE TABLE Regns
sn INT NOT NULL
By: Sean Lange
How do I represent a view to post on in a topic?
CREATE TABLE [dbo].[TableTemp](
[BASEL_CATEGORY] [varchar](50) NULL,
[EC_DRAWN] [numeric](18, 6) …
By: Gail Shaw
I've been wracking my brain over this one and it is slowly sending me into a spiral of madness...
7 years, 11 months ago
I'm quite new on this forum but it's really a great place.
I have a question for some great exp…
I have table that contains lottery data :
CREATE TABLE dbo.tblLottery
I thought I'd try using throw instead of raiseerror in my application, to try to remove the…
8 years ago
By: seth delconte
I have been using the following syntax in prior versions and it worked, however when I try it in 20…
Viewing 15 topics - 4,801 through 4,815 (of 4,822 total)
You must be logged in to create new topics.