TSQL

It is a very critical step to correctly determine SQL Server Data Types when designing tables to prevent unnecessary growth of the database. The space …

  In this article I will describe how to declare variables in TSQL. We can declare variables in a few different ways. • Declare a …

We can perform the following operations with ALTER TABLE Statement. Add a column to a table Delete a column from a table Change the data …

You can use GRANT, REVOKE, and DENY commands on many database objects in SQL Server. With the GRANT command, you can authorize a user. With …

  In SQL Server, you can write query in a query. You can write the subqueries in the SELECT section, FROM section, and the WHERE …

  When filtering through the Where Clause during data reading from the database, the IN operator can check whether the column is within certain values. …

  When reading data from the database with Between Operator, we can specify a range for the data we filter in WHERE Clause. Let’s make …

With Distinct Clause, you can return only one of the recurring records as a result when reading data from the table. In other words, if …

  When reading data from the database, we can use GROUP BY clause when we want to group data and process on the groups we …

  With Order By Clause, you can sort the records returned as a result of the Select statement as ascending or descending according to the …