SQL Express 2005 - need an auto increment ID column
Hi,
I need to create a table which has an auto indexing ID column. I've done this in Access and hope I can do it in SQL Express as well.
Any suggestions.
thanks,
newbieweb
I need to create a table which has an auto indexing ID column. I've done this in Access and hope I can do it in SQL Express as well.
Any suggestions.
thanks,
newbieweb
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Oops.. the second insert should read
INSERT myTable(field1) values ('Second Record')
but it doesn't matter--it works either way.
INSERT myTable(field1) values ('Second Record')
but it doesn't matter--it works either way.
ASKER
I ran the first one, but still can not find the table.
How do I find it?
How do I find it?
ASKER
With both queries I had success. But in neither case could I find where the new table was placed. Any ideas about how to search for it?
ASKER
Or how about is there a way to provide a namespace to the table name so I can have it created inside a given database?
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
I got :
Command(s) completed successfully.
But I can't find the table. Any suggestions?