InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 12:58:20 GMT20http://www.sqlservercentral.com/Forums/Topic1386690-203-1.aspxya thanks for that:-)Tue, 20 Nov 2012 02:24:44 GMTch.omkarreddyhttp://www.sqlservercentral.com/Forums/Topic1386690-203-1.aspx[quote][b]ch.omkarreddy (11/20/2012)[/b][hr]in the above i mentioned,the requirement of client is that he need transaction_id starting with 6 digit number and auti-incrementing.......[/quote] that is what i explained plus link i gave youTue, 20 Nov 2012 00:20:54 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1386690-203-1.aspxin the above i mentioned,the requirement of client is that he need transaction_id starting with 6 digit number and auti-incrementing.......Tue, 20 Nov 2012 00:04:46 GMTch.omkarreddyhttp://www.sqlservercentral.com/Forums/Topic1386690-203-1.aspx[quote][b]ch.omkarreddy (11/19/2012)[/b][hr]the above table i created should have its transactio_id auto-incremented begining with 6 digit number[/quote] 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 [url]http://www.howtogeek.com/howto/database/reset-identity-column-value-in-sql-server/[/url]Mon, 19 Nov 2012 23:46:18 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1386690-203-1.aspxCREATE 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!!!!!!!!!!!Mon, 19 Nov 2012 23:28:06 GMTch.omkarreddy