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.
create trigger FixDataMC1 on MC1LINE2 after update, insert, delete as update MC1LINE2 set [Date] = REPLACE([Date], '"', ''), [Time] = REPLACE([Time], '"', ''), [VACUUM_PRESS.] = REPLACE([VACUUM_PRESS.], ',', '') update MC1LINE2 set [Date] = '20' + [Date] where LEN([Date]) <=8 delete from MC1LINE2 where [No.] like '%No.%' go
BULK INSERT vw_bulk_insert_test FROM '\\172.27.10.11\MC1-LINE #2\MC01-2013-0120-0448.csv' WITH ( FIELDTERMINATOR =',', ROWTERMINATOR = '\n', FIRE_TRIGGERS )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.