Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.
Begin Transaction INSERT INTO users (church,contact,taxnum,phone,address,city,state,zip,email,username,password,code) SELECT church,contact,taxnum,phone,address,city,state,zip,email,username,password,code FROM application WHERE id = @id INSERT INTO UserCOC (COC) SELECT (COC) FROM application WHERE id=@id -- UserCOC also has 2 fields which do not allow nulls -- 1) UserID which is a FK with users.id being the primary key -- 2) COCAdmin which is a bit which needs to be set to 'False' initially UPDATE users SET DateStarted = getdate() WHERE id = @id DELETE FROM application WHERE id = @id ROLLBACK Transaction END
Join the community of 500,000 technology professionals and ask your questions.