Creating a stored procedure in Microsoft SQL Server
Creating a Stored Procedure in Microsoft SQL Server
What is an aggregate function?
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.
Handling Strings in SQL Server
“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?”
How to use Parameters in Stored Procedures?
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.
How to use a QUALIFY clause in SQL?
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.
Why is my SQL query taking so long?
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.