Options
Server assigned id as input for SQL Statement
dunski
Posts: 3
Is it possible to use a server assigned identity column in a SQL statement generator?
For example, I have an Account table with a primary key AccountId which is an autoassigned identity column. That same table has an AccountNumber column.
I want to use the following SQL statement generator to populate AccountNumber:
SELECT fn_GenerateAccountNumber(AccountId);
Thanks!
For example, I have an Account table with a primary key AccountId which is an autoassigned identity column. That same table has an AccountNumber column.
I want to use the following SQL statement generator to populate AccountNumber:
SELECT fn_GenerateAccountNumber(AccountId);
Thanks!
Comments