create table cust ( id int identity(1,1), cname varchar(20), myid varchar(50) )
select cname+''+convert(varchar(50),id) as myid from cust where id=max(id)+1
id cname myid ------------------------------------------------------- 1 abc abc1
CREATE PROCEDURE uspNewCustomer @custname NVARCHAR(50) BEGIN DECLARE @myid INT = 0 --in case of error, return zero INSERT INTO Customers (CustomerName) VALUES(@custname) SET @myid = @@IDENTITY() UPDATE Customers SET MyID = CustomerName + CONVERT(VARCHAR(10), @myid) --RETURN newely inserted value SELECT @myid END
select
myID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)