-- Для добавление
 
PARAMETERS [CURR_ID:] Long = NULL, [NAME:] Text (  255  ) = NULL;
INSERT INTO CURRENCY_LST([CURR_ID], [NAME]) VALUES [CURR_ID:], [NAME:]);

 -- Для изменения
 
PARAMETERS [CURR_ID:] Long = NULL, [NAME:] Text (  255  ) = NULL;
UPDATE CURRENCY_LST SET [NAME]=[NAME:] WHERE CURR_ID=[CURR_ID:];

CREATE PROCEDURE Add2Currency
@Curr_ID INT,
@Name VARCHAR( 100 )

AS

DECLARE @iCheck INT

SET @iCheck = SELECT TOP  1  Curr_ID FROM Currency_LST WHERE Curr_ID=@Curr_ID

IF @iCheck IS NULL BEGIN
  INSERT ...
END
ELSE BEGIN
  UPDATE ...
END