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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
ASKER
I got :
Command(s) completed successfully.
But I can't find the table. Any suggestions?