11,849
社区成员
发帖
与我相关
我的任务
分享
create proc [dbo].[GetTableInfoByOption]
(
@TableName nvarchar(30),
@Option nvarchar(30),
@Num nvarchar(20),
@IsNew nvarchar(2),
@Keyword nvarchar(20)
)
as
exec('select top '+@Num+' * from '+@TableName+' where ParentID='+@Keyword+' and IsNew='+@IsNew+' order by ModifyTime desc')