November 19, 2012 at 11:28 pm
CREATE TABLE STUDENTLOGIN(username varchar(30),
password varchar(30),
created_by_id varchar(20),
created_date varchar(20),
updated_id varchar(20),
updated_date datetime,
transaction_id numeric(12));
the above table i created should have its transactio_id auto-incremented begining with 6 digit number,
please help me!!!!!!!!!!!
November 19, 2012 at 11:46 pm
ch.omkarreddy (11/19/2012)
the above table i created should have its transactio_id auto-incremented begining with 6 digit number
your requirement is not clear here but what i can assume here is you want to start this identity column with value 100000 ..right ??? if yes then see this link http://www.howtogeek.com/howto/database/reset-identity-column-value-in-sql-server/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 12:04 am
in the above i mentioned,
the requirement of client is that he need transaction_id starting with 6 digit number and auti-incrementing.......
November 20, 2012 at 12:20 am
ch.omkarreddy (11/20/2012)
in the above i mentioned,the requirement of client is that he need transaction_id starting with 6 digit number and auti-incrementing.......
that is what i explained plus link i gave you
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 20, 2012 at 2:24 am
ya thanks for that
🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply