Use Excel to write insert SqlScript

="insert into Process.dbo.TempHampInGoodStandingLoanList (Loan_No,ProgramType,ModificationEffectiveDate) values(RIGHT('0000000000' + '"&A5&"',10),'"&B5&"','"&TEXT(C5,"yyyy-MM-dd HH:mm:SSS")&"')"

posted @ 2014-12-22 10:16  伟杰Andy  阅读(137)  评论(0编辑  收藏  举报