how to use(or) create int identity in stored procedure

Question

how to use int identity in stored procedure

Deepak Verma · Answer

Hi If you want to generate row number have a look on this ROW_NUMBER (Transact-SQL) . And you can use  emp_id as int identity(11) when creating temporary tables inside a Stored Procedure.

selvi subramanian · Answer

ya i want to increase the value .we use in query as (Example emp id as int identity(11) ) how to use identity in stored procedure)

Vithal Wadje · Answer

yes as manish sir suggested explain your problem in detail

Manish Dwivedi · Answer

Hi Selvi Can you define your problem in more detail? Thanks