indradeo kumar

indradeo kumar

  • 1.2k
  • 548
  • 7.7k

can any one share me asp c# code to mention sql asp c# code

Jan 28 2020 10:55 AM
Dear Sir ,
 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
 

Answers (1)