Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
teedah1
Starting Member
10 Posts |
 Posted - 2007-04-13 : 10:28:46
|
| Hi, I have a dynamic search form in an .asp page and for everytime a user clicks submit, it goes to SQL to query the search string from the form's text field. this form will also allow the user to insert new items which when submitted, will be inserted into SQL. however i need to generate a dynamic ID each time a new entry is created in sql. how do i insert this dynamic ID into sql? thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-13 : 11:08:42
|
| "however i need to generate a dynamic ID each time a new entry is created in sql"Can you use a column with Integer datatype and the IDENTITY property?Kristen |
 |
|
|
teedah1
Starting Member
10 Posts |
Posted - 2007-04-13 : 11:56:54
|
| great! that did it. that was easy :-) |
|
|
|
|
|
|
dynamic ID generation in SQL