[dba-SQLServer] Data Types

Thanks, looks like that will do it for me!!!!

	-----Original Message----- 
	From: Francisco H Tapia [mailto:my.lists at verizon.net] 
	Sent: Wed 6/16/2004 10:43 AM 
	To: dba-sqlserver at databaseadvisors.com 
	Cc: 
	Subject: Re: [dba-SQLServer] Data Types
	
	

	It's the Integer field and you set it to have seed value of (whatever
	value you want to start at) and an Identity increment of 1 (or whatever
	you see fit).
	
	Jeff Barrows wrote On 6/16/2004 5:55 AM:
	
	>What is the best way to create an auto numbering field for SQL?  I am upsizing an Access 97 database to SQL and need to keep some fields as autonumbers.
	>
	>Jeff B
	> 
	>
	
	
	--
	-Francisco
	
	
	_______________________________________________
	dba-SQLServer mailing list
	dba-SQLServer at databaseadvisors.com
	http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
	http://www.databaseadvisors.com