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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-15 : 08:19:18
|
| Douglas writes "Is there a quasi simple way (ie. 5-10 tsql lines), function, etc., to "programmatically" create an incremented integer value when inserting a new record that does NOT utilize the identity data type and function?I'm familiar with the use of the identity function and data type, but want to create an environment that does not use this method, for flexibility reasons.I've read your article on alternatives to identity, but it only focuses on variations of the identity data type and function.djs422" |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2004-03-15 : 08:52:46
|
Why reinvent the wheel?Sure there are ways, but I like to think, that Microsoft has somewhat optimized that feature for multi-user, heavy load environments.  --Frankhttp://www.insidesql.de |
 |
|
|
|
|
|
"Programmatic" alternative to identity