Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
18297 Points
2740 Posts
Apr 22, 2012 09:56 AM|LINK
Set the no. column as identity column. So the values are generated automatically. Then from the front end, you must insert only the name using the insert command like:
insert into read (name) values ('SomeName')
See the following link for more inof:
http://msdn.microsoft.com/en-us/library/ms188059.aspx
adeelehsan
All-Star
18297 Points
2740 Posts
Re: Adding serial no in to .mdf database
Apr 22, 2012 09:56 AM|LINK
Set the no. column as identity column. So the values are generated automatically. Then from the front end, you must insert only the name using the insert command like:
insert into read (name) values ('SomeName')
See the following link for more inof:
http://msdn.microsoft.com/en-us/library/ms188059.aspx
MCPD ASP.NET 4.0 and 3.5, MCTS WSS, MOSS, SharePoint 2010, MCT
Microsoft Community Contributor Award 2011