路在脚下

摘要： 能过参数查询存储过程。select b.namefrom dbo.syscomments a,dbo.sysobjects b where a.id=b.id and b.xtype='p' and a.text like '%insert into%'修改为默认dbo对象exec sp_changeobjectowner '要改的表名','dbo'批量修改：EXEC sp_MSforeachta... 阅读全文

摘要： create function [dbo].[split](@SourceSql varchar(8000),@StrSeprate varchar(10))returns @temp table(F1 varchar(100))asbegin declare @i int set @SourceSql = rtrim(ltrim(@SourceSql)) set @i = charindex(@... 阅读全文