首页 > 代码库 > Use Excel to write insert SqlScript

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")&"‘)"

Use Excel to write insert SqlScript