Create Proc [dbo].[flyso_list]
( --Coding By flyso
@TableName nvarchar(100), --表名
@dispnum int, --条数
@Field nvarchar(1000), --字段
@Condition nvarchar(1000), --条件
@Order nvarchar(100) --排序
)
AS
BEGIN
SET NOCOUNT ON
DECLARE @sC1 nvarchar(400),@sO1 nvarchar(400)
DECLARE @strSQL nvarchar(1000)
Select @sC1=''
IF LEN(@Condition)>2
BEGIN
Select @sC1=' Where '+@Condition+' '
END
IF LEN(@Order)>2
SET @sO1=' orDER BY '+@Order
SET @strSQL='Select TOP '+CAST(@dispnum AS nvarchar)+' '+@Field+' FROM '+@TableName+@sC1+@sO1
EXEC(@strSQL)
END