求一条SQL语句~~急！

[BestCoding]

有这样一个存储过程：
alter proc GetNewsByNChar
@Number int,
as
declare @Stute nchar(1)
set @Stute = 'Y'

exec('select top ' + @Number + ' * from News' +
' where bStute = ' + @Stute + ' order by nid desc')
return 0

在查询分析器中执行，返回信息是： 列名 'Y' 无效。

bStute的类型是nchar(1)
现在SQL的语句放在exec里面，不懂怎样给字符串赋值，使用\'来添加单引号把字符Y括在里面，
但是不成功。
还请大家帮帮忙，感谢！

[OracleRoob]

alter proc GetNewsByNChar
@Number int
as
declare @Stute nchar(1)
set @Stute = 'Y'

exec('select top ' + cast(@Number as varchar(100)) + ' * from News' +
' where bStute = ''' + @Stute + ''' order by nid desc')
return 0

[子陌红尘]

...
exec('select top '+rtrim(@Number)+' * from News where bStute='''+@Stute+ ''' order by nid desc')
...

[OracleRoob]

alter proc GetNewsByNChar
@Number int
as
declare @Stute nchar(1),@s nchar(2000)
set @Stute = 'Y'
set @number =10
set @s= 'select top ' + cast(@Number as varchar(100)) + ' * from News' +
' where bStute = ''' + @Stute + ''' order by nid desc'

select @s
exec (@s)

return 0

[BestCoding]

不行，返回： 列名 'Y' 无效

exec('select top ' + @Number + ' * from News' +
' where bStute = ' + @Stute + ' order by nid desc')
我是想得到如下的结果：
select top 10 * from News
where bStute = 'Y' order by nid desc

现在的问题出在，不知道如何把字符Y传给bStute

[OracleRoob]

--这个语句也有问题？

create proc GetNewsByNChar
@Number int
as
declare @Stute nchar(1),@s nchar(2000)
set @Stute = 'Y'
set @number =10
set @s= 'select top ' + cast(@Number as varchar(100)) + ' * from News' +
' where bStute = ''' + @Stute + ''' order by nid desc'

select @s
exec (@s)

return 0

[BestCoding]

老大，是真的~~！

打印出来是：
select top 10 * from News
where bStute = "Y" order by nid desc

如果是单引号就肯定没问题，但双引号编译报错

[OracleRoob]

要使用单引号，在SQL语句语法中没有使用双引号的地方

[OracleRoob]

select top 10 * from News
where bStute = "Y" order by nid desc

--这样的SQL语句执行肯定通不过

[BestCoding]

哎呀，大意了，把你写的'''看成了"'

哈哈哈~~~问题解决~~~麻烦你了！