Browse by Tags

Tagged Content List
  • Wiki Page: How to Put a Sequence in a Column Already filled

    Suppose we would like to create a sequence in a table already filled with data. I found out this solution to be pretty easy: CREATE TABLE SEQ (COK NVARCHAR( 10 )) insert into seq values ( 'York' ),( 'Boston' ),( 'Chicago' ) select * from seq --step 1 , I create a table...
  • Wiki Page: Sequence Object in SQL Server 2012

    The Release of SQL Server 2012 introduces the sequence object to the world of SQL Server. A sequence is a user defined, schema bound object that will generate a sequence of numeric values (in ascending or descending order) according to specification. Unlike identity columns, a sequence is created independent...
Page 1 of 1 (2 items)
Can't find it? Write it!