CREATE PROCEDURE TESS222 @num int =1 AS declare @sql varchar(2000) set @sql = 'SELECT TOP ' + rtrim(10*@num) + ' id FROM [内容表] ORDER BY 发布时间 DESC' EXEC(@sql) GO
CREATE PROCEDURE TESS222 @num int =1 AS exec('SELECT TOP '+10*@num+' id FROM [内容表] ORDER BY 发布时间 DESC') GO
CREATE PROCEDURE TESS222 @num int =1 AS declare @sql varchar(2000) set @sql =N'SELECT Top 10*'+@num+' id FROM [内容表] ORDER BY 发布时间 DESC' EXEC(@sql) GO
CREATE PROCEDURE TESS222 @num int =1 AS DECLARE @SQL NVARCHAR SET @SQL=CAST(10*@NUM AS NVARCHAR) EXEC(N'SELECT TOP ' + @SQL + ' id FROM [内容表] ORDER BY 发布时间 DESC') GO
AS
declare @sql varchar(2000)
set @sql = 'SELECT TOP ' + rtrim(10*@num) + ' id FROM [内容表] ORDER BY 发布时间 DESC'
EXEC(@sql)
GO
exec('SELECT TOP '+10*@num+' id FROM [内容表] ORDER BY 发布时间 DESC')
GO
AS
declare @sql varchar(2000)
set @sql =N'SELECT Top 10*'+@num+' id FROM [内容表] ORDER BY 发布时间 DESC'
EXEC(@sql)
GO
@num int =1
AS
DECLARE @SQL NVARCHAR
SET @SQL=CAST(10*@NUM AS NVARCHAR) EXEC(N'SELECT TOP ' + @SQL + ' id FROM [内容表] ORDER BY 发布时间 DESC')
GO