can any one share me asp c# code to mention sql query.
CREATE TABLE [dbo].[Test]
(
[Id] INT NOT NULL PRIMARY KEY,
[ pr_name] VARCHAR(50) NULL,
[ pr_price] VARCHAR(50) NULL,
[UniqueID] VARCHAR(50) NULL
)
DECLARE @Test AS TABLE(Id INT,pr_name VARCHAR(10),pr_price INT)
SELECT *,SUBSTRING(pr_name,1,3)+RIGHT('000'+CONVERT(VARCHAR(3), Id),3) UniqueID FROM @Test