20 lines
470 B
Transact-SQL
20 lines
470 B
Transact-SQL
USE [DD_ECM]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[PRCUST_ADD_HISTORY_STATE] Script Date: 21.03.2024 17:07:58 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
CREATE PROCEDURE [dbo].[PRCUST_ADD_HISTORY_STATE] @MessageID VARCHAR(250), @TITLE1 VARCHAR(250), @TITLE2 VARCHAR(250), @COMMENT VARCHAR(3000) = 0
|
|
AS
|
|
BEGIN
|
|
INSERT INTO TBEMLP_HISTORY_STATE
|
|
(MESSAGE_ID,STATE_TITLE,STATE_TITLE1,COMMENT) VALUES (@MessageID,@TITLE1,@TITLE2,@COMMENT)
|
|
END
|
|
GO
|
|
|
|
|