Creating a stored procedure in Microsoft SQL Server
August 7, 2023
Creating a Stored Procedure in Microsoft SQL Server
Advanced SQLTransact-SQLWhat is an aggregate function?
October 19, 2022
An aggregate function where the values are grouped together to form a single response. The more common SQL aggregate functions are SUM, COUNT, AVG, MIN and MAX.
Advanced SQLSQL TutorialsSQL tutorials for beginnersTransact-SQLHandling Strings in SQL Server
October 17, 2022
“How could I split a SQL field by a delimiter?”, “How could I get with the first word of a SQL field?”, “How could I get the first three letters of an SQL field?”
Advanced SQLSQL TutorialsSQL tutorials for beginnersTransact-SQLHow to use Parameters in Stored Procedures?
October 15, 2022
The Stored Procedures are an elegant way to store your code inside a SQL database. You can save your code and reuse it whenever you want to.
Advanced SQLPL/SQLSQL TutorialsTransact-SQLHow to use a QUALIFY clause in SQL?
October 7, 2022
Qualify may be one of the most underestimate commands in SQL, as a Data Analyst, I use it a lot and I really hope after this tutorial you use it too.
Advanced SQLPL/SQLSQL TutorialsTransact-SQLWhy is my SQL query taking so long?
October 4, 2022
This is one of the questions we almost always ask ourselves. In this article, we are going to learn a bit about how to make an efficient query.
Advanced SQLMiscellaneousPL/SQLTransact-SQL