What are the challenges you face when working across database platforms? Take the survey
Options

Server assigned id as input for SQL Statement

dunskidunski 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!

Comments

Sign In or Register to comment.