stuart-d2
9/10/2014 - 5:08 PM

INSERT INTO

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