出错

[My_first]

set @sql = 'declare cur_id cursor for select max('+'dh'+') from mxsb where convert(char(10),mdate,120)='''+@Mydate+''''
exec(@sql)
Open cur_id
fetch next from cur_id into @Maxid


改为下面的就出错
set @sql = 'declare cur_id cursor for select max('+'dh'+') from mxsb where substring(dh,12,4) as char)='+@userbh+'convert(char(10),mdate,120)='''+@Mydate+''''
exec(@sql)
Open cur_id

我加了一句substring(dh,12,4) as char)='+@userbh+'

[CABO]

max('+'dh'+')

是什么写法？好像还没见过

可以加一个GROUP BY，或者用子查询

[zqllyh]

declare @mydate char(10),@sql varchar(3000),@userbh char(10)
set @sql = 'declare cur_id cursor for select max('+'dh'+') from mxsb
where substring(dh,12,4) ='+@userbh+ ' and convert(char(10),mdate,120)='''+@Mydate+''''
exec(@sql)

[KnowLittle]

你加的这个什么意思?

[nielisheng]

substring(dh,12,4) as char

or substring(dh,12,4) = '+@userbh+'

[KnowLittle]

是"找感觉"这个意思吗?不会巴,这么简单,楼主会不知道吗?

[zqllyh]

exec('declare cur_id cursor for select max( dh) from mx
sb
where substring(dh,12,4) ='+ @userbh + ' and convert(char(10),mdate,120)= ' + @Mydate )

[愉快的登山者]

语法不对，应为：
set @sql = 'declare cur_id cursor for select max('+'dh'+') from mxsb where substring(dh,12,4) as char)='+@userbh+'convert(char(10),mdate,120)='''+@Mydate+''''