Re: Stored Procedure - SQL Parameters

[Peter Brawley]

There's one way to pass params to an sproc, and the time it takes is trivial compared with how long a query takes.

Note that if emp_id is a column name in tblXeroContacts, the query will not behave as expected---ie always using a param-naming convention.that makes such errors impossible.

To investigate why the query is slow, run explain extended on it, and post the result along with the result of Show Create Table tblXeroContacts.