Database reference - demo

demo -  procedures -  ml_server.ml_upload_update_device_address

Description

none

Procedure properties

namevalue
nameml_server.ml_upload_update_device_address 
created 
typeSQL stored procedure 

Parameters

namedatatypelengthin/outcomment
@addressvarchar255in 
@activevarchar1in 
@devicevarchar255in 
@mediumvarchar255in 


Usage

EXEC ml_server.ml_upload_update_device_address
    @address = @myvarchar1,
    @active = @myvarchar2,
    @device = @myvarchar3,
    @medium = @myvarchar4

Code

create procedure ml_server.ml_upload_update_device_address( 
  in @address varchar(255),
  in @active varchar(1),
  in @device varchar(255),
  in @medium varchar(255) ) 
begin
  call ml_set_device_address(@device,@medium,@address,@active,'n','tracking')
end



Documentation generated by SqlSpec