create procedure Psp_AllComzizhi
@num int,
@strwhr VarChar,
@order Varchar
AS
BEGIN
declare @sql varchar(max)
set @sql=' select top '+ @num +' * from tb_Comzizhi where '+@strwhr+' order by '+@order
exec(@sql)
END
GO
@num int,
@strwhr VarChar,
@order Varchar
AS
BEGIN
declare @sql varchar(max)
set @sql=' select top '+ @num +' * from tb_Comzizhi where '+@strwhr+' order by '+@order
exec(@sql)
END
GO