you can use row_number function an increament by 1

CREATE SEQUENCE Test.CountBy1 START WITH 1 INCREMENT BY 1 ; GO SQL Sequence. Sequence is a feature supported by some database systems to produce unique values on demand

Visit following link for answer http://www.interviewquestionspdf.com/2017/06/how-to-generate-sequence-without-using.html