-
Understanding Microsoft SQL CROSS APPLY and OUTER APPLY Operators
Microsoft SQL has two variants i.e. CROSS APPLY and OUTER APPLY. Both operators are in SQL used to perform table-valued function /correlated subqueries against rows in another table. CROSS APPLY It is similar to an INNER JOIN i.e. It returns rows from the left table that have a matching row in the right table. No… Read more
-
SQL – Information of TRY, CATCH and Error Handling
In SQL Deadlocks are very crucial things which we need to handle with ease, So for this features, You can do whatever if any error occur.@@ERROR is not used for every statement executed then.TRY and CATCH helps to write logic and error handling code differenly.Whatever code need to execute you can write in TRY block… Read more
Follow My Blog
Get new content delivered directly to your inbox.
