How do I generate autonumber for a column which will follow a certain format. Say I want it to S001, S002, S003 and etc. so i want the 1st word to be S. And I want this auto number to be pri key as well..
Bklr -1 - you need to wrap all that stuff into transactions and lock the table, making all inserts serial, and you'd need to adapt to perform inserts of any significant size. Fine if you have no option but with SQL Server you do have one.