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 […]
In this tutorial, we’ll look at the set operators used in TSQL. Set operators and Joins work very similar but the biggest difference is that, in set operators, the result set is a superimposed table made out of the two tables used in the select statement. That is, the columns are not repeated, the values from […]