在SQLServer2005查询分析器里,执行:
insert into y8_CompanyList (loginName,loginPass,companyLinkman,companyPhone,companyEmail1,companyName) values('aa' , 'aa' , 'aa' , 'aa' , 'aa' , 'aa')正常插入数据,但是改成下面的就不行:exec 'insert into y8_CompanyList (loginName,loginPass,companyLinkman,companyPhone,companyEmail1,companyName) values(''aa'' , ''aa'' , ''aa'' , ''aa'' , ''aa'' , ''aa'')'谁能告诉我哪里出错?怎么改?
insert into y8_CompanyList (loginName,loginPass,companyLinkman,companyPhone,companyEmail1,companyName) values('aa' , 'aa' , 'aa' , 'aa' , 'aa' , 'aa')正常插入数据,但是改成下面的就不行:exec 'insert into y8_CompanyList (loginName,loginPass,companyLinkman,companyPhone,companyEmail1,companyName) values(''aa'' , ''aa'' , ''aa'' , ''aa'' , ''aa'' , ''aa'')'谁能告诉我哪里出错?怎么改?
--加括号
exec ('insert into y8_CompanyList (loginName,loginPass,companyLinkman,companyPhone,companyEmail1,companyName)
values(''aa'' , ''aa'' , ''aa'' , ''aa'' , ''aa'' , ''aa'')')