Create Function Strings Examples

This example shows you how to create a function string for the rs_begin function that begins a transaction in the database by executing a stored procedure named begin_xact.

create function string rs_begin
 for gateway_func_class
 output rpc 'execute begin_xact'

This example shows you how to create a function string for a rs_insert function that references the publishers_rep replication definition, which executes an RPC at the replicate database as a result of an insert in the primary table. The stored procedure insert_publisher is defined only at the replicate database.

create function string publishers_rep.rs_insert
    for rs_sqlserver_function_class
    output rpc
    'execute insert_publisher
      @pub_id = ?pub_id!new?,
      @pub_name = ?pub_name!new?,
      @city = ?city!new?,
      @state = ?state!new?'