12 lines
270 B
Transact-SQL
12 lines
270 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_update_inquiry]
|
|
@character_id uniqueidentifier,
|
|
@type tinyint,
|
|
@memo nvarchar(255)
|
|
as
|
|
set nocount on
|
|
|
|
UPDATE [dbo].[InquiryTable] SET
|
|
[type] = @type,
|
|
[memo] = @memo WHERE [character_id] = @character_id
|
|
|
|
return @@error
|