How can we help you today? How can we help you today?

Server assigned id as input for SQL Statement

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!
dunski
0

Comments

1 comment

Sort by
  • dunski
    Nevermind... Solved this with a simple trigger :)
    dunski
    0

Add comment

Please sign in to leave a comment.