CREATE TABLE [dbo].[tbl_Product](
[Id] [int] IDENTITY(101,1) NOT NULL,
ProductId As 'PRO'+Right('000'+convert (varchar(10),Id),6)persisted,
[ProductName] [nvarchar](100) NULL,
[Quantiy] [int] NULL,
[Price] [decimal](18, 1) NULL,
[CreateOn] [datetime] NULL
) ON [PRIMARY]
Id ProductId ProductName Quantiy Price CreateOn
101 PRO000101 Wiproo 100 Walt Blub 100 120.0 NULL
No comments:
Post a Comment