Hi,
I am new to SQL Server platform, i want to define primary keys automatically other than using an identity. For a table called indicator i want it primary keys to be like ind_001, ind_002, ind_003 and so on.
Can anybody help me on how to do this? I am new to this platform so i will appreciate it if suggestions are explained very clearly. Thank you
You will either have implement this in your fronent logic or use triggers to reset the values inserted to the appropiate pattern.
Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment