SQL Server v.Next (Denali) : Deriving sets using SEQUENCE

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Mon, 13 Dec 2010 12:58:00 GMT Indexed on 2010/12/13 13:12 UTC
Read the original article Hit count: 681

Filed under:

Denali

|

sequence

|

SQL 11

|

SQL Server 11

|

SQL Server 2011

|

t-sql

One complaint about SEQUENCE is that there is no simple construct such as NEXT (@n) VALUES FOR so that you could get a range of SEQUENCE values as a set. In a previous post about SEQUENCE , I mentioned that to get a range of rows from a sequence, you should use the system stored procedure sys.sp_sequence_get_range . There are some issues with this stored procedure: the parameter names are not easy to memorize; it requires multiple conversions to and from SQL_VARIANT; and, producing a set from the...(read more)

© SQL Blog or respective owner

Related posts about Denali

SQLAuthority News – What’s New in SQL Server “Denali”

as seen on SQL Authority - Search for 'SQL Authority'
I was today doing SQL Server Advanced Training at Bangalore and I had few attendees asked me if I can give them review of the SQL Server Denali. I had not downloaded Denali on my work computer so I could not do demonstration of the same. However, I promised to blog about with additional details very… >>> More
SQL Server Denali - Serverless SQL Server

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Who hates having to install SQL Express to get SQL Server. Anyone ever used those automatigally attached databases you can do with SQL Express. Yes! Wow you must be the only one. SQL express whilst its awesome to have a free version of SQL its a total pain to install. OK you could go with SQL Compact… >>> More
SQL SERVER – Online Session on What is New in Denali – Today Online

as seen on SQL Authority - Search for 'SQL Authority'
I will be presenting today on subject Inside of Next Generation SQL Server – Denali online at Zeollar.com. This sessions are really fun as they are online, downloadable, and 100% demo oriented. I will be using SQL Server ‘Denali’ CTP 1 to present on the subject of What is New in… >>> More
Introducing SSIS Reporting Pack for SQL Server code-named Denali

as seen on SQL Blog - Search for 'SQL Blog'
In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali: What's new in SSIS in Denali Introduction to SSIS Projects in Denali Parameters in SSIS In Denali SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali… >>> More
SQL SERVER – What is Denali?

as seen on SQL Authority - Search for 'SQL Authority'
I see following question quite common on Twitter or in my email box. “What is Denali?” Denali is code name of SQL Server 2011. Here is the list of the code name of other versions of SQL Server. In 1988, Microsoft released its first version of SQL Server. It was developed jointly by Microsoft… >>> More

Related posts about sequence

using Quick Sequence Diagram Editor for sequence diagrams

as seen on Stack Overflow - Search for 'Stack Overflow'
Anyone have experience with Quick Sequence Diagram Editor? The combination of instant display + text source code + Java implementation is very attractive to me, but I can't quite figure out how to make the syntax do what I want, and the documentation's not very clear. Here's a contrived example: al:Actor bill:Actor atm:ATM[a] bank:Bank[a] al:atm… >>> More
SQL SERVER – 2011 – Introduction to SEQUENCE – Simple Example of SEQUENCE

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server 2011 will contain one of the very interesting feature called SEQUENCE. I have waited for this feature for really long time. I am glad it is here finally. SEQUENCE allows you to define a single point of repository where SQL Server will maintain in memory counter. USE AdventureWorks2008R2 GO CREATE… >>> More
ORA-03113 in code. In addition, TNS-12535 and ORA-03137 in alert file

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got an exception that contain ORA-03113: (SiPPSS.GetPrintWorkDirectDetail) - ERR:ORA-03113: end-of-file on communication channel Process ID: 7448 Session ID: 30 Serial number: 9802 ?????:12110937 ????:T855 Oracle.DataAccess.Client.OracleException ORA-03113: end-of-file on communication channel… >>> More
Task Sequence boots to logon screen instead of task sequence mode

as seen on Server Fault - Search for 'Server Fault'
I'm running a task sequence, and so that users don't accidentally interfere, I have the task sequence reboot to currently installed operating system, which as I understand, is supposed to boot to a sort of single user mode and all that shows is task sequence progress. However, this does not happen… >>> More
create a random sequence, skip to any part of the sequence

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone, In Linux. There is an srand() function, where you supply a seed and it will guarantee the same sequence of pseudorandom numbers in subsequent calls to the random() function afterwards. Lets say, I want to store this pseudo random sequence by remembering this seed value. Furthermore… >>> More