SQL to APS Automation
This script was designed to help make importing data from any SQL2008+ database to an APS much easier.
2015-08-12 (first published: 2015-07-14)
971 reads
This script was designed to help make importing data from any SQL2008+ database to an APS much easier.
2015-08-12 (first published: 2015-07-14)
971 reads
Something like this should get you most of the way: create TRIGGER [name] ON FOR INSERT AS update set created_by = SUSER_SNAME(), last_modified_by = SUSER_SNAME(), date_created = GETDATE(), date_last_modified = GETDATE() from inserted where .Seqno = inserted.seqno; create TRIGGER [name] ON FOR UPDATE AS update set last_modified_by = SUSER_SNAME(), date_last_modified = GETDATE() from inserted where […]
2004-07-29
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers