Jump to content

In Sql Auto Increment


shyam
 Share

Recommended Posts

SQL Server calls that an identity field, you need to make it an integer, not null, primary key, and in the properties panel make it an identity field.
hello sir,can YOU please tell me a query for below table or procedure to do socrate table tablenameid int,name varchar(20),and birthdate varchar(10)I WANT TO INCREMENT ""ID""thanks for last reply Edited by fasttrack
Link to comment
Share on other sites

THANK YOU SIRTHANKU ALLI GOT THE ANSWER..........CREATE TABLE new_employees( id_num int IDENTITY(1,1), fname varchar (20), minit char(1), lname varchar(30))INSERT new_employees (fname, minit, lname)VALUES ('Krin', 'M', 'JREs')

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...