摘要： createPROCEDUREUSP_GetDetail(@ObjectNamenvarchar(50))asBegindeclare@typevarchar(10)select@type=[type]fromsys.objectswith(nolock)wherename=@ObjectNamecase@typeWHEN'U'THENexec('selectcount(1)as总行数from'+@ObjectName+'with(nolock)')exec('selecttop100*from'+@ObjectName+' 阅读全文