Making a pkey

Hi everyone. I put this post on the MS SQL forum but never got a reply. I am using coldfusion to insert information to a database that is MS SQL. I am trying to have a specific autonumber that will assign to each entry. let me know if anyone knows how to do this ....

Hi everyone. I am trying to build forms that when users fill out the form it will create an PK that has a naming convention of the year, project, and the number of the request from that project. Is this possible? One of the fields on the form is a drop down that would have the project number listed in it so it would give them the option to pick project number - i want it to look like so -

yy-2329-001
date - project number pulled from drop down - number of requests auto numbered for this project

anyone have any ideas on how to do this. I am using coldfusion if anyone needs code to help with that. I am not sure if I have to do this in coldfusion or in MS SQL. thanks.

When you create the table, you define what column(s) are the primary key, as well as the format of the key. You can do this via the SQL MMC (management console) in Windows, or you can define it in DDL statements if you are creating the tables with SQL statements. This doesn't really have anything to do with CF, it's a SQL Server task.