Check this: http://www.sqlservercentral.com/articles/T-SQL/63003/

Also you can pass it as XML parameter, parse and insert it.

Thanks,

Nikul

You can pass it as XML parameter, parse and insert it.

Thanks,

Nikul

You can use third party red-gate SQL packager.

Thanks,

Nikul

you can disable the constraint

ALTER TABLE 'table name' NOCHECK CONSTRAINT all

ALTER TABLE 'table name' DISABLE TRIGGER all

Thanks,

Nikul

Here you go.

--- Create Schema/User

IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'db_executor' AND type = 'R')

DROP ROLE [db_executor]

/* CREATE A NEW ROLE */

CREATE ROLE db_executor

Thanks,

Nikul

You can use the internal tables INSERTED and the DELETED and find out what to do.

Thanks,

Nikul

I tried on AdventureWorks and found no issue.

SELECT

e.[EmployeeID]

,c.[Title]

,c.[FirstName]

,c.[MiddleName]

...