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