Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
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.