Generate unique id in a sequence in SQL Server

amitsinghr says:

dear sir i want to genrate ID form my Customer table 

like 

Cust1302170001

where cust is constant 130217 represent today date 

0001 this is customer number

 

this i want to auto increment when customer data is inserted 

using stored procedure 

 

Hi amitsinghr,

While saving you need to check the existence of Customer count with today’s date and add plus one with Constant string along with current count value plus one. You need to handel it while saving as it belong to current count logic