I am using SQL Server 2005 and I need to create a primary key with an alpha character and 3 numbers together:
I know I need to create a rule and bind that rule to the primary key column. I am little confused in creating the rule using a
CREATE RULE pK-rule AS @pk LIKE'[a-z][0-9][0-9][0-9]'
Can anybody suggest what I need to change?