Tree RenameItem

CREATE PROCEDURE [dbo].[tree_tst-catalog_renameItem]
    @id nvarchar(128),
    @name nvarchar(128),
    @username nvarchar(32)
AS
BEGIN
    update tst_categories
    set name = @name
    where id = @id

    declare @code nvarchar(max), @url nvarchar(max)

    set @code = dbo.cat_getCategoryCode(@id)
    update tst_categories set code = @code where id = @id

    set @url = dbo.cat_getCategoryURL(@id)
    update tst_categories set url = @url where id = @id

    -- SELECT 1
    Select 1 Result, '' Msg
END