how to increment the value in store procedure.

May 27 2012 11:37 PM

how to increment the value in store procedure.i need like this Emp1001,Emp1002,Emp1003., with coding in sqlserver