create custom id in sql using Asp.net Web forms

Hi Garima,

You can create functions or directly write these type code into stored proc.

https://www.sqlteam.com/articles/custom-auto-generated-sequences-with-sql-server

https://www.kodyaz.com/t-sql/custom-sequence-string-as-sql-identity-column.aspx

create function NextCustomerNumber() 
returns char(5) 
as 
begin 
	declare @lastval char(5) 
	set @lastval = (select max(customerNumber) from Customers) 
	if @lastval is null set @lastval = 'AG0001' 
	declare @i int 
	set @i = right(@lastval,4) + 1 
	return 'AG' + right('000' + convert(varchar(10),@i),4) 
end

https://steemit.com/database/@virajtakke09/how-to-generate-unique-id-character-number-for-customer-in-sql-server

The easiest way is to define the table such that you don't need to insert tha value manually from applictaion.

CREATE TABLE Test
   (
      UserID VarChar(1000) AS 'FM'+Scope_Identity()
      ,Name Varchar(150)
    );

Now, you don't need to enter the value of UserID