|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 16th, 2004, 10:44 AM
|
|||
|
|||
Default Value
Hello there,
i would like to know if there is a way to set a field in my SQL database table so it inserts a value every time there is a new record in the table. I mean something like the option in MSAccess 'Autonumber' or 'Autonumeric' or something like that. Thanx. 
__________________
"It is impossible to make anything foolproof because fools are so ingenious". Murphy. 
|
|
#2
January 16th, 2004, 11:58 AM
|
||||
|
||||
|
The SQL Server equivalent of Accesses Autonumber is Identity. Is that what you are wanting to know?
|
|
#3
February 26th, 2004, 07:27 AM
|
|||
|
|||
|
What if you want to copy an integer in one column and insert it in another column as a varchar on INSERT?
Markus Quote:
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Default Value |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
