identity field + constraints for a table

[Costas]

source - http://stackoverflow.com/a/27523976

SQL Server

-insert/write into identity field
-disable all constraints for table

--source - http://stackoverflow.com/a/20249170

--disable all constraints for a table
ALTER TABLE Toys NOCHECK CONSTRAINT ALL

--disable all constraints for ALL tables
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT ALL";

 
 

--disable all constraints for ALL tables
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT ALL";

--delete all from table
delete from [Toys]

--enable to write @ IDENTITY field
SET IDENTITY_INSERT Toys ON
GO

--bulk insert
INSERT INTO [Toys]
	([Toy_ID], [Toy_Language_ID], [Toy_SEO_ID], [Toy_Source])
VALUES 
	(1, 1, 1, '<meta charset="utf-8" />'),
	(2, 2, 1, '<meta charset="utf-8" />');
GO

--re-enable IDENTITY field
SET IDENTITY_INSERT Toys OFF
GO

--enable all constraints
EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL";