Architect

Difference between Stored Procedure  and User Defined Function in SQLServer Sl. No. User-Defined function Stored Procedure 1 The function must return a value. The stored procedure may or not return values. 2 Will allow only Select statements, it will not allow us to use DML statements. Can have select statements as well as DML statements such as insert, update, delete, etc 3 It will allow only input parameters and doesn’t support output parameters. It can have both input and output parameters. 4 It will not allow us to use try-catch blocks. For exception handling, we can use try-catch blocks. 5 Transactions are not allowed within functions. Can use transactions within Stored procedures. 6 We can use only table variables, it will not allow using temporary tables. Can use both table variables as well as a temporary table in it. 7 Stored procedures can’t be called from function. Stored Procedures can call functions. 8 Functions can be called from a select statement. Procedures can’t b...

 Difference between LEFT JOIN and LEFT OUTER JOIN in SQL Server there is no difference between LEFT JOIN and LEFT OUTER JOIN . SELECT * FROM Customers C    LEFT JOIN Orders O      ON O.CustomerId = C.CustomerId SELECT * FROM Customers C    LEFT OUTER JOIN Orders O      ON O.CustomerId = C.CustomerId CONCLUSION From the above various examples we can see that there is absolutely  NO DIFFERENCE between LEFT JOIN and LEFT OUTER JOIN . Even though both produces the same result and performance, I would prefer using LEFT OUTER JOIN instead of just LEFT JOIN. As it is more readable and leaves no ambiguity. Please share which one you use and reason for the same.