开发者

Incorrect syntax near the keyword "Primary"

开发者 https://www.devze.com 2023-03-04 02:20 出处:网络
I have this error message but i cannot find any wrongdoing, help? const string sql = @\"SELECT PrimarySchool,TopHonour,Cca,TopStudent,TopAggregate,TopIm开发者_Go百科age FROM Primary\";

I have this error message but i cannot find any wrongdoing, help?

const string sql = @"SELECT PrimarySchool,TopHonour,Cca,TopStudent,TopAggregate,TopIm开发者_Go百科age FROM Primary";


primary is a reserved keyword in TSQL. Make it SELECT ...(snipped)... FROM [Primary]" to escape it and indicate you mean the object named Primary.

0

精彩评论

暂无评论...
验证码 换一张
取 消