Few days
back I got a question and started binging. I didn’t find any,
finally started writing this tutorial.
What is the
query? To understand the query, you need to consider a scenario. Let me
describe that first.
It is a very common requirement to use “out”
parameter in SQL Server. The characteristic of this parameter is to return
values to calling functions or more specifically, to front end.
Where to
use? Consider a scenario, where your table has got an Auto generated ID field;
And you want the generated ID to be returned back in user interface. Also consider that your organization strictly
follows 3 layer architecture.