CREATE PROCEDURE SelectTopNumber
@number int
AS
SET ROWCOUNT @number
select * from authors order by au_ID
GO
@number int
AS
SET ROWCOUNT @number
select * from authors order by au_ID
GO
调试欢乐多
你说的是什么方法呀,我想知道,难道是id>* and id<*
N'select top @number * from NewsInfo where NewsType = @type',
N'@number INT',
N'@type INT',
参数1,
参数2
exec ('select top '+ cast(@number as varcahr(10) +' * from NewsInfo where NewsType = '+ @type)
DECLARE @VCnumber varcahr(10)
SET @VCnumber=cast(@number as varcahr(10)
exec ('select top '+ @VCnumber +' * from NewsInfo where NewsType = '+ @type)
create procedure up_name
@type varchar(2),
@number intasDECLARE @VCnumber varcahr(10)
SET @VCnumber=cast(@number as varcahr(10)
exec ('select top '+ @VCnumber +' * from NewsInfo where NewsType = '+ @type)