declare @cnt int set @cnt=(select MAX(SUBSTRING(Account_Admin.Account_Id,2,LEN(Account_Admin.Account_Id)))+1 from Account_Admin) DECLARE @Account_Id VARCHAR(20) SET @Account_Id = 'A'+CAST(@cnt as varchar)
declare @cnt int select @cnt =MAX(SUBSTRING(Account_Admin.Account_Id,2,LEN(Account_Admin.Account_Id)))+1 from Account_Admin DECLARE @Account_Id VARCHAR(20) SET @Account_Id = 'A'+CAST(@cnt as varchar)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)