摘要:
ALTER proc [dbo].[RoleUser](@RoleID varchar(20),@UserID varchar(20))asdeclare @count intset @count=(select count(PTU_Sub) from PT_Role where PTR_ID=@RoleID)declare @Sub varchar(200)set @Sub=(select PTU_Sub from PT_Role where PTR_ID=@RoleID)declare @newSub varchar(200)set @newSub=(@Sub+','+@U 阅读全文
摘要:
create function fenge(@SourceSql varchar(8000),@StrSeprate varchar(10))returns @temp table(a varchar(100))as begindeclare @i intset @SourceSql=rtrim(ltrim(@SourceSql))set @i=charindex(@StrSeprate,@SourceSql)while @i>=1begin insert @temp values(left(@SourceSql,@i-1)) set @SourceSql=substring(@Sour 阅读全文