="insert into ModuleInfo(ModuleCode,ModuleName) values('"&A1&"','"&B1&"')"
结果:insert into ModuleInfo(ModuleCode,ModuleName) values('序号','表名称')
="select top 0 * into "&B2&"_SdueptLog from "&B2&""
结果:select top 0 * into Customer_SdueptLog from Customer
="ALTER TABLE "&B2&"_SdueptLog ADD OPText NVARCHAR(20),LogText NVARCHAR(20),LogCreatedOn DATETIME"
结果:ALTER TABLE Department_SdueptLog ADD OPText NVARCHAR(20),LogText NVARCHAR(20),LogCreatedOn DATETIME
excel 公式:
最新推荐文章于 2021-08-05 09:15:37 发布