随笔分类 -  MSSQL Server

摘要：Create proc [dbo].[sp__search] @str Nvarchar(1000) --要搜索的字符串 as if @str='' return declare @s Nvarchar(4000) create table #t(表名 sysname,字段名 sysname) declare tb cursor local for select s='if exists(select 1 from ['+replace(b.name,']',']]')... 阅读全文