Tag: SQL Server Management Studio

SQL Temp Tables And Views For Power BI User

SQL Temp Tables And Views For Power BI User - Enterprise DNA

In this tutorial, we’ll discuss SQL temp tables and views. These two can be handy if you want to pull a specific set of data from a physical table for testing and debugging. We’ll also talk about the 2 types of temporary tables and their differences. With SQL temp tables and views, you can freely

Continue reading

Aggregate Functions In SQL And Their Usage

Aggregate Functions In SQL And Their Usage - Enterprise DNA

In this tutorial, we’ll be discussing the different aggregate functions in SQL and how we can use them. In SQL, aggregate functions are used to accumulate data from multiple rows into a single summary row.  Aggregate functions in SQL can be very helpful for analysts when doing data summarization. Commonly Used Aggregate Functions In SQL

Continue reading

Stored Procedures In SQL | An Overview

Stored Procedures In SQL An Overview - Enterprise DNA

In this blog, we’re going to discuss stored procedures in SQL that you can utilize to save a set of code and use it repeatedly whenever you need it. Stored procedures are similar to views. However, you can conduct common table operations such as DROP, TRUNCATE, DELETE, etc. with stored procedures which you can’t perform

Continue reading

HAVING Clause In SQL Aggregate Functions

HAVING Clause In SQL Aggregate Functions - Enterprise DNA

In this tutorial, we’ll be discussing a few ways in which we can use or execute the HAVING Clause in SQL aggregate functions. Using this clause in SQL aggregate functions can greatly help in data summarization. HAVING Clause is almost similar to WHERE statement and can also be executed along with it. We’ll discuss their

Continue reading