sp_sql_get_next_row_id

sp_sql_get_next_row_id

This modifier retrieves the next available row ID in a specified table and reserves a number of ID’s (specified by the @to_borrow parameter) in the table for the script executing the procedure.

sp_sql_get_next_row_id

 

Parameters

Value

Description

Notes

@cur_table

t_table_name

The name of the table being retrieved.

 

@row_id

integer output

The ID of the next available row.

 

@to_borrow

integer = 1

The number of ID’s needed by the script (must be greater than zero).

 

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.