Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

need a urgent help Expand / Collapse
Author
Message
Posted Monday, November 19, 2012 11:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, November 19, 2012 11:46 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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
Post #1386696
Posted Tuesday, November 20, 2012 12:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, November 20, 2012 12:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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
Post #1386706
Posted Tuesday, November 20, 2012 2:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 22, 2012 1:16 AM
Points: 7, Visits: 14
ya thanks for that
Post #1386749
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse