CREATE PROCEDURE [recruit].SP_UPDATE_MST_PROVINCE
@province_id      char(5),
@province_name varchar(50),
@sap_code  char(2),
@created_by  varchar(8),
@flag   char(1)
AS
 UPDATE [recruit].MST_PROVINCE
 SET province_name = @province_name,
                     sap_code = @sap_code,
        created_date =  convert(char(8),getdate(),112),
         created_by = @created_by,
        flag  = @flag
 WHERE province_id  = @province_id

GO