Sunday, 9 September 2012

Create table having auto increamented column in Sql Server

Create table reg_tab
(
id int not null identity(1,1),
fname varchar(50),
addr varchar(100),
email varchar(50),
contact numeric(12,0),
CONSTRAINT reg_tab_pk PRIMARY KEY(id)
)


0 comments:

Post a Comment


                                                            
 
Design by Abhinav Ranjan Sinha