一句sql求解？

[ICeeYeS]

Exec('SELECT top '+@Num+' Convert(Varchar(5),notice_time,110) as notice_time,notice_title,notice_main,notice_id ,notice_type FROM Notice WHERE notice_type='+@Type+' order by Notice_time')

@num是5，@Type为 公告
执行结果为列‘公告’无效。

问问大家该这么改这句。

[dobear_0922]

Exec( 'SELECT top '+@Num+ ' Convert(Varchar(5),notice_time,110) as notice_time,notice_title,notice_main,notice_id,notice_type FROM Notice WHERE  notice_type= '''+@Type+ '''  order   by   Notice_time ') 

[dobear_0922]

Exec( 'SELECT top '+@Num+ ' Convert(Varchar(5),notice_time,110) as notice_time,notice_title,notice_main,notice_id,notice_type FROM Notice 
WHERE  notice_type= '''+@Type+ '''  order   by   Notice_time ') 

[中国风]

'''+@Type+ ''' --@Type两边少了单引号

[elvis_gao]

@Num为整数吧，把 +@Num+ 改成 +convert(nvarchar,@Num)+

[elvis_gao]

@Num为整数吧，把 +@Num+ 改成 +convert(nvarchar,@Num)+

[ICeeYeS]

right，thanks

[elvis_gao]

没见过这么蠢的程序，我提交第一遍蹦错，重新写一遍提交，出现两条我的记录，改版后的csdn，真牛！

[cqllzp]

楼上说我的不懂。。。。。。。。

[liangCK]

1,2,3楼都说啦..
我接分..