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 […]
In today’s discussion, I’m focusing on one important component of T-SQL, that is sub queries. As the name implied, a sub query is simply a query that is made up of outside query and inside query. This means, one query is embedded inside another query. The are two types of sub queries, regular sub queries and […]