need a urgent help

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Jeff Moden » need a urgent help

need a urgent help

Rate Topic

Display Mode

Topic Options

Author

Message

ch.omkarreddy

Posted Monday, November 19, 2012 11:28 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 22, 2012 1:16 AM
Points: 7, Visits: 14

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!!!!!!!!!!!

Post #1386690

Bhuvnesh

Posted Monday, November 19, 2012 11:46 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1386696

ch.omkarreddy

Posted Tuesday, November 20, 2012 12:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 22, 2012 1:16 AM
Points: 7, Visits: 14

in the above i mentioned,

the requirement of client is that he need transaction_id starting with 6 digit number and auti-incrementing.......

Post #1386699

Bhuvnesh

Posted Tuesday, November 20, 2012 12:20 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1386706

ch.omkarreddy

Posted Tuesday, November 20, 2012 2:24 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 22, 2012 1:16 AM
Points: 7, Visits: 14

ya thanks for that
Smile

Post #1386749

« Prev Topic | Next Topic »

Permissions