How to use sequence method in sqlserver?

X

vasavivenu

New Member

Join Date: Feb 2011

Posts: 37
#1

How to use sequence method in sqlserver?

Mar 11 '11, 07:20 AM

Hi,
How can i use sequence method in sql server? i have to change Mysql code to Sql server,

Code:

SELECT nextval('Country_Mst_Seq') NextVal

I need to change the above code into sql server. please help me

Thanks in Advance
vasavivenu

Last edited by Niheel; Mar 11 '11, 08:03 AM.
Tags: None

Previous template Next