sp_prepexec Used to prepare and execute a parameterized SQL statement. This command combines the functions of the sp_prepare and sp_execute procedures and is available from SQL2000 onwards. Syntax sp_prepexec [@handle =] statement_handle OUTPUT, [@paramdef =] N'parameter_name data_type, [,...n]' [@stmt =] N'stmt', {, [@param1 =] value1 [,...n] } Arguments [@handle =] statement_handle Is the name..