Saturday, 16 June 2018
How to add auto increament with string of number and letter?
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]
Output-
Subscribe to:
Posts (Atom)
How to convert plugin assembly (dll) into base 64 bytes using console application (C#).
using System; using System.IO; using System.ServiceModel.Description; using Microsoft.Rest; using Microsoft.Xrm.Sdk; using Microsoft.Xrm.Sd...
-
CREATE Procedure SP_PaymentToSupplierEmployee_Periodically @tbl_OrganizationId nvarchar(50) AS BEGIN SET NOCOUNT ON; SELECT COUNT(...
-
CREATE TABLE [dbo].[tbl_dbLogs]( [LogSerialId] [int] IDENTITY(1,1) NOT NULL, [Error_line] [int] NULL, [ERROR_MESSAGE] [nvarchar](max...
-
Data Base:- CREATE TABLE [dbo].[tbl_registration]( [FormID] [int] IDENTITY(1,1) NOT NULL, [ModelName] [nvarchar](50) NULL, [RegFee...