Squence Query in SQL SERVER

Select Squence Query in SQL SERVER :

-It can be used Automatic Generation number without column in the table can use Sequence concept.

 

select      (

      ROW_NUMBER()

      over (Order by EmpId))as Rownumber,

      EmpId,

      EmpName,

      EmpSalary  

      from Sequence_Tbl

Continue Reading