exec 执行SQL的问题

[xiaoma208]

用exec 执行：
'select top 10 a.khh as khh, b.khmc as khmc, a.zjye as zjye, a.zqsz as zqsz, a.zzc as zzc,
case when a.zzc=0 then 0 else a.zqsz/a.zzc end as ccbl from b_zlzl_khzczwzl a, b_cjzl_khzl b,
(select khh,max(rq) rq from b_zlzl_khzczwzl group by khh) c where a.rq = c.rq and a.khh = b.khh and a.khh = c.khh '
不是有效的标识符。
why?

[hai2003xp]

exec ( 'select top 10 a.khh as khh, b.khmc as khmc, a.zjye as zjye, a.zqsz as zqsz, a.zzc as zzc,case when a.zzc=0 then 0 else a.zqsz/a.zzc end as ccbl
from b_zlzl_khzczwzl a, b_cjzl_khzl b,(select khh,max(rq) rq from b_zlzl_khzczwzl group by khh) c
where a.rq = c.rq and a.khh = b.khh and a.khh = c.khh ' )

這樣寫會有問題嗎？是不是你的哪個字段名拼寫錯了？

[lxysjl]

应该没有错啊

[xiaoma208]

declare @sql varchar(8000)
set @sql = 'select top 10 a.khh as khh, b.khmc as khmc, a.zjye as zjye, a.zqsz as zqsz, a.zzc as zzc,case when a.zzc=0 then 0 else a.zqsz/a.zzc end as ccbl
from b_zlzl_khzczwzl a, b_cjzl_khzl b,(select khh,max(rq) rq from b_zlzl_khzczwzl group by khh) c
where a.rq = c.rq and a.khh = b.khh and a.khh = c.khh '
exec @sql

我是这样执行出错的：不是有效的标识符。