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

Browse More Articles

Tweet

Written by Test

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.