Guide for CTE in SQL Server
The Common Table Expression aka CTE in SQL Server provides a temporary result set in T-SQL. You can...
How to SHOW or LIST Tables in MySQL
There are two primary methods to view the tables in MySQL: In this article, we are going to explore them both....
How to Use a ROUND Function in SQL Server
The ROUND function in SQL Server is a powerful tool that allows you to round numeric values to a specific number of decimal places. This...
SQL AS: Usage, Examples, and How it Can Benefit You Best
What is the AS statement in SQL? The AS keyword in SQL is used to create a temporary alias for a...
How to Get SQL Server Statistics Information Using System Statistical Functions
Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL...
SQL Server RAISERROR Statement with Simple Examples
The SQL RAISERROR statement is used to send a custom message to the client application. It also can be used to debug the application and...
Stored Procedure to Delete Duplicate Records in SQL Table
Sometimes during our run as DBAs, we come up across at least one table that is loaded with...
What is a Materialized View and Why Should you Use It?
As data volumes continue to increase, more developers look towards materialized views to process queries. This approach has a lot of...
How to Write Complex Queries in SQL
Typical queries in the SELECT * FROM table format are sometimes not enough. When the data for a query is not in one table, but in several,...
SQL Stuff Function
The main idea around the SQL Server function called STUFF is concatenating multiple columns into a...