Database reference - demo

demo -  procedures -  ml_server.ml_qa_upsert_global_prop

Description

none

Procedure properties

namevalue
nameml_server.ml_qa_upsert_global_prop 
created 
typeSQL stored procedure 

Parameters

namedatatypelengthin/outcomment
@clientvarchar128in 
@namevarchar128in 
@modifiersinteger4in 
@valuelong varchar32767in 


Usage

EXEC ml_server.ml_qa_upsert_global_prop
    @client = @myvarchar1,
    @name = @myvarchar2,
    @modifiers = @myinteger3,
    @value = @mylong varchar4

Code

create procedure ml_server.ml_qa_upsert_global_prop( in @client varchar(128),
  in @name varchar(128),
  in @modifiers integer,
  in @value long varchar ) 
begin
  insert into ml_qa_global_props( client,name,modifiers,value ) on existing update defaults off
    values( @client,@name,@modifiers,@value ) 
end



Documentation generated by SqlSpec