INSERT INTO
/*e.g., */
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway');
***
/*simple*/
INSERT INTO [SET.Tagging].[dbo].[TagVendors] (Name)
VALUES ('Adobe DTM');
***
/*multiple*/
INSERT INTO[SET.Tagging].[dbo].[TagTemplates] (TagVendorId, Name, Text)
VALUES ('19', 'Adobe DTM Script', '<script src="//assets.adobedtm.com/12d9f7e5992f5c962fff7e0e62a5689e3a634f73/satelliteLib-f47f86c4b38f968792dd46e690a96958251aab44-staging.js"></script>');
***
/*date time inserts and Identity. Was having a hell of a time inserting the date/time until I just made it a string... */
SET IDENTITY_INSERT subscription ON
INSERT INTO subscription
( subscription_id, modem_id, moultrie_plan_id, billable, free_reason, free_reminder_date, begin_on, end_on, cc_processor_subscription_id)
VALUES
(98, 48, 6, 1, '', '2015-10-07 20:36:22.607', '2015-10-07 20:36:22.607', '2015-10-07 20:36:22.607', 'temp Id')
SET IDENTITY_INSERT subscription OFF