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)
Dynamics 365 Ribbon Button JavaScript customization function- Displays a popup message when the button is clicked.
function RequestRibbonCustomisation(primaryControl) { var formContext = primaryControl; alert("Coming soon! Work in Progress....
-
CREATE Procedure SP_PaymentToSupplierEmployee_Periodically @tbl_OrganizationId nvarchar(50) AS BEGIN SET NOCOUNT ON; SELECT COUNT(...
-
CRM does not allow direct download of the DLL file from the UI . However, there are several ways to retrieve the plugin DLL from the CRM e...
-
var It is introduced C#3.0 Version. dynamic It is introduced C# 4.0 version 1).Var is statically type of variable, where are dyna...