Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement