create procedure GetInfoByItemId
@itemId int,
@num int
as
begin
declare @sql varchar(3000)
set @sql='select top '+cast(@num as varchar(15))+' infoid,infoTitle from gxdxs_info where infoModuleItemId=@itemid order by infoid desc'
exec(@sql)
end
@itemId int,
@num int
as
begin
declare @sql varchar(3000)
set @sql='select top '+cast(@num as varchar(15))+' infoid,infoTitle from gxdxs_info where infoModuleItemId=@itemid order by infoid desc'
exec(@sql)
end
@itemId int,
@num int
as
begin
declare @sql nvarchar(200)
set @sql=N' select top '+convert(varchar,@num)+
N' infoid,infoTitle from gxdxs_info '+
N' where infoModuleItemId=@itemid '+
N' order by infoid desc'
exec sp_executesql @sql,N'@itemId int',@itemId
end