Skip to main content
Share Your Experience: Take the 2024 Developer Survey
1 vote

Stored procedure with output parameters in MSSQL

If you want to optimize the query and use out parameters to return IDs please refer to below code: ...
hassaan mustafa's user avatar
1 vote

Stored procedure with output parameters in MSSQL

You're looking for a JOIN. SELECT i.id, l.pid, l.sid FROM invoice i JOIN log l ON i.pid = l.pid WHERE i.batchid = @batchid; Use EXPLAIN SELECT ... to verify the ...
J_H's user avatar
  • 28.2k

Only top scored, non community-wiki answers of a minimum length are eligible