18 lines
No EOL
576 B
Transact-SQL
18 lines
No EOL
576 B
Transact-SQL
IF OBJECT_ID('dev.uspRenameExistingDictionaryElement') IS NOT NULL BEGIN
|
|
DROP PROCEDURE dev.uspRenameExistingDictionaryElement
|
|
END;
|
|
GO
|
|
|
|
CREATE PROCEDURE dev.uspRenameExistingDictionaryElement
|
|
@newId int
|
|
,@name nvarchar(100) --a user által beszúrandó dictionary elem neve
|
|
,@type nvarchar(100) --dictionary típusa
|
|
,@suffix nvarchar(100)=N'_002' --már létező dictionary elem után írandó suffix
|
|
AS
|
|
BEGIN
|
|
UPDATE T_DICTIONARYITEMBASE
|
|
SET C_NAME += @suffix
|
|
WHERE C_NAME=@name AND C_TYPE=@type AND ID<>@newID
|
|
|
|
RETURN @@ROWCOUNT
|
|
END |