Monthly Archives: February 2017

SQL: Different ways to generate sequence

There was a question from the op regarding adding a new column to a query output by generating the cyclic sequence numbers from 1 to 3. Select A =identity(int,1,1),B,C from table_abs 1,A,41 2,B,13 3,C,90 4,D,91 5,E,98 6,F,12 7,G,54 8,H,16 For … Continue reading

Posted in SQL, SQL 2012, Uncategorized | Tagged , , | 2 Comments