Interviews - C# Corner

Vikas Ahlawat
How to Generate Sequence without using Ranking functions in SQL Server?
By Vikas Ahlawat in SQL Server onJul 06 2017
  • Gajendra Jangid
    Jan, 2018 20

    you can use row_number function an increament by 1

    • 2
  • Sathiya Moorthy
    Dec, 2017 23

    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

    • 2
  • Vikas Ahlawat
    Jul, 2017 6

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

    • 2
  • Chandan Prasad
    Aug, 2018 7

    we can achieve this by NEWID function.select COUNT(*) over (order by ID, concat(ID,NEWID())) UniqueNumber, ID from tblNumber

    • 0

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS