• SQL Server
• ::
• Table Structure
• ::
• SET IDENTITY_INSERT

subject:SET IDENTITY_INSERT
syntax:SET IDENTITY_INSERT tbl_name { ON | OFF }
GO
content:ใช้กำหนดว่าจะให้คำสั่ง IDENTITY มีผลหรือไม่
example:CREATE TABLE tbl_orders
(
	id int IDENTITY NOT NULL,
	price money NOT NULL,
	discount int NOT NULL,

	CONSTRAINT tbl_orders_pk PRIMARY KEY (id),
)
SET IDENTITY_INSERT tbl_orders OFF;
INSERT INTO tbl_orders ( id, price, discount ) VALUES ( "1", 200, 12 );
INSERT INTO tbl_orders ( id, price, discount ) VALUES ( "2", 500, 25 );
SET IDENTITY_INSERT tbl_orders ON;
INSERT INTO tbl_orders ( price, discount ) VALUES ( 200, 12 );
INSERT INTO tbl_orders ( price, discount ) VALUES ( 500, 25 );