Constraint

How to create table in SQL Server

USE Arm_DB Go IF (OBJECT_ID(‘TBL_Product’,’U’) IS NOT NULL) DROP TABLE TBL_Product Go CREATE TABLE TBL_Product ( ID INT IDENTITY(1,1) ,NAME NVARCHAR(50) ,Price DECIMAL(10,2) ,[Desc] NVARCHAR(MAX) ,InsertedDate DATETIME DEFAULT SYSDATETIME() ,MOdifiedDate DATETIME DEFAULT SYSDATETIME() CONSTRAINT PK_TBL_Product PRIMARY KEY (ID) ) GO… Read More ›