Generate Sequence number with Prefix in sql server

DECLARE @intFlag INT

SET @intFlag = 1

WHILE (@intFlag <=10)

BEGIN

print 'B'+RIGHT('00000'+ CONVERT(VARCHAR,@intFlag),6)

SET @intFlag = @intFlag + 1

END

GO

OUTPUT

C# syntax to Generate Sequence number with Prefix

int sequenceNumber = 5;

string id = string.Format("PT{0}", sequenceNumber.ToString().PadLeft(13, '0'));

OUTPUT

PT0000000000001 , PT0000000000002 , PT0000000000003 ,PT0000000000004 ,PT0000000000005