Identity function

[week]

I am not aware of anything like this but anyone knows any existing function that will create identity column with yyyymm at the end as part of the ID?

Thanks.

 

[smin]

This can be done using an insert trigger.

Create Trigger triggername on YourTable
For Insert
As

update YourTable
set YourColumn = YourIdentityColumn + cast(getdate() as string)

Something like that.

 

[week]

Sounds like a good idea!! Thanks.