@@Identity, Scope_Identity(), and Ident_Current() are used to fetch the last inserted identity value. Most of the cases, we find that these functions return the same value indicating to an identity column. But these function are not really same, they show different behaviour at different scenario [More]
In SQL Server 2005 Cross Apply and Outer Apply operator are used to refer a table-valued function in a correlated sub query.
These operations are similar to SQL Joins operations. SQL joins are used to relate information in different tables whereas Apply clause is used to relate information in a table and a table-valued-function. [More]
Calling SSRS reports from front end in ASP.net can be acheived in few steps: Steps: 1. Create a web application project. 2. Add a report 3. Create dataset and parameters(if needed) in the report 4. Define the layout of the report....... [More]