In the last tutorial, l discussed stored procedures. Stored procedures are used for implementing the complex logic of a business while functions are commonly used for specific tasks. Do not confuse a stored procedure for a function, also remember there are system functions which are provided by the SQL Server. There are lot of system […]
In TSQL Tutorial 16, l discussed and implemented the various types of user defined stored procedures. I’m going to continue the discussion and probably end my discussion about stored procedures in this tutorial with some very important things to know about stored procedures apart from just writing the query to create them. In the last […]
In this tutorial, I’m going to discuss one of the most important database objects that you’ll ever come across in SQL Sever Programming, that is Stored Procedures. Stored Procedures are T-sql statements written, pre-compiled and stored in the database which can accept one or more parameters and return one or more parameters. The server stores […]
l want to take on three topics in this tutorial. That is temporary tables, derived tables and table variables. l want to take on all of them at once so l can compare and discuss the technical implementation of all of them at the same time. l hope you understand what a table is, in […]
