Rookie
|
| Posted: 09/09/2004, 10:22 AM |
|
I need to move my DataBase from Access to SQL, and its almost done.
the question is: How I declare the primary key as AUTOINCREMENTED, as I do in Access??????
ASP, SQL
|
|
|
 |
dataobjx
Posts: 181
|
| Posted: 09/09/2004, 10:44 AM |
|
From within SQL Server Enterprise Manager select your database then the table.
Right click on the table name and click "design".
Click on the gray area to the left of the primary key field name to select the row you want as the primary key.
Next, from the top menu - click the "KEY" Icon (looks like a house or car key).
Finally under the fields grid there is a tab called "Columns" that has a number of properties you can set.
Locate the property called "Identity" and select "Yes" from the picklist.
Save your table.
That's it.
_________________
www.DataObjx.net
www.mydigitalapps.com |
 |
|
Rookie
|
| Posted: 09/09/2004, 11:45 AM |
|
Thanks
...detailed and quick response
|
|
|
|
|
