The new sequence object in sql 2012 cannot be formatted

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

The new sequence object in sql 2012 cannot be formatted

Postby gvarol@corelogic.com » Wed Jul 11, 2012 2:37 pm

anywhere in the script file if the last line below is used it causes an error.

CREATE SEQUENCE [dbo].[ReportComparisonSeq] AS INT START WITH 1 INCREMENT BY 1 NO CYCLE CACHE 10
go
DECLARE @Seq INT
SELECT @Seq = NEXT VALUE FOR [dbo].[ReportComparisonSeq]
gvarol@corelogic.com
 
Posts: 63
Joined: Wed Mar 09, 2011 9:43 pm
Location: USA

Postby Manfred.Castro » Thu Jul 12, 2012 6:49 pm

Unfortunately although the majority of our products support connections to SQL 2012. We do not as of yet support all the new features of SQL 2012.
You can request a feature to include 2012 syntax at out uservoice forums.
http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests