cs_user_rename.prc

解压即可使用

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cs_User_Rename]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[cs_User_Rename]
GO


CREATE procedure [dbo].cs_User_Rename
(
	@UserID	int,
	@NewUserName nvarchar(64)
)
AS
BEGIN
	DECLARE @ROWCOUNT INT
	DECLARE @ERROR INT
	
	BEGIN TRAN

	-- aspnet_Users UserName
	UPDATE u SET 
		u.UserName 		= @NewUserName 
		,u.LoweredUserName 	= LOWER(@NewUserName)
	FROM aspnet_Users u
	INNER JOIN cs_Users c ON
			c.MembershipID = u.UserID
	WHERE c.UserID = @UserID

	SELECT @ROWCOUNT = @@ROWCOUNT, @ERROR = @@ERROR
	IF( @ERROR <> 0 )
	BEGIN
		ROLLBACK TRAN
		RETURN 1
	END

	-- cs_weblog_weblogs MostRecentPostAuthor
	UPDATE cs_weblog_weblogs SET MostRecentPostAuthor = @NewUserName where MostRecentPostAuthorID = @UserID
	IF( @ERROR <> 0 )
	BEGIN
		ROLLBACK TRAN
		RETURN 1
	END

	-- cs_Posts PostAuthor
	UPDATE cs_Posts SET PostAuthor = @NewUserName where UserID = @UserID
	IF( @ERROR <> 0 )
	BEGIN
		ROLLBACK TRAN
		RETURN 1
	END

	-- cs_Threads PostAuthor
	UPDATE cs_Threads SET PostAuthor = @NewUserName where UserID = @UserID
	IF( @ERROR <> 0 )
	BEGIN
		ROLLBACK TRAN
		RETURN 1
	END

	-- cs_Sections MostRecentPostAuthor
	UPDATE cs_Sections SET MostRecentPostAuthor = @NewUserName where MostRecentPostAuthorID = @UserID
	IF( @ERROR <> 0 )
	BEGIN
		ROLLBACK TRAN
		RETURN 1
	END

	COMMIT TRAN
	RETURN 0
END


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

GRANT EXECUTE ON [dbo].[cs_User_Rename] TO PUBLIC
GO