命令未正确结束

[bjsxtdenggy]

select t.deptname,t.professionalname,t.name,t.score from BK t where 1=1 AND department = 2bbde1c0-7973-4d2e-8a55-2f101b41c1d6 AND specialty =66dd43a4-b310-49e0-bb98-b101320d7e8c AND MONTH between 1 and 12 ORDER BY SCORE DESC 命令未正确结束是怎么回事

[q8097559]

你的 from BK t 对表另起别名了 貌似要这样 where1 =1 and t.department=... and t.specialty= and......

[wolf863292]

检查字符串的单引号，或者结尾的分号。

department = '2bbde1c0-7973-4d2e-8a55-2f101b41c1d6'

[jackson_fighting]

varchar类型的需要用 ''

[hoojo]

[Quote=引用 2 楼 的回复:]

检查字符串的单引号，或者结尾的分号。

department = '2bbde1c0-7973-4d2e-8a55-2f101b41c1d6'
[/Quote]++

select t.deptname,t.professionalname,t.name,t.score from BK t where 1=1 AND department = '2bbde1c0-7973-4d2e-8a55-2f101b41c1d6' AND specialty ='66dd43a4-b310-49e0-bb98-b101320d7e8c' AND MONTH between 1 and 12 ORDER BY SCORE DESC
字符串 用''