CREATE PROCEDURE NaviGationUpt
(
@NaviId int,
@NaviName varchar(20),
@NaviUrl varchar(200),
@NaviState int
)
AS 
BEGIN TRY

UPDATE NaviGation SET
NaviName = @NaviName,
NaviUrl = @NaviUrl,
NaviState =@NaviState 
WHERE 
NaviId =@NaviId

PRINT 1
END TRY

BEGIN CATCH
SET NOCOUNT ON;
DECLARE @MGS VARCHAR(500)=error_message()
PRINT 0
END CATCH