From the beginning of SQL Server, we used to filter data from any table with the help of WHERE Clause. Can we filter data without WHERE clause? The answer was a Big NO before Azure Data Studio but it is possible in Azure Data Studio. Curious?
Let me demostrate it with the help of examples.
Example 1: (Filter single column data)
- Using SQL Server Management Studio (SSMS):
In SSMS, we use WHERE clause in order to filter the data as shown below.
USE AdventureWorks2019
GO
SELECT BusinessEntityID
, FirstName
, LastName
, ModifiedDate
FROM Person.Person
WHERE FirstName = 'Abraham';
GO
--OUTPUT
- Using Azure Data Studio:
Step 1:
First of all, you need to write a query without WHERE clause and run it. After that just click on show filter button as highlighted below and it opens up the filter window.
Step 2:
In this step, you just need to select the respective value, which you want to filter. Since I selected FirstName as “Abraham” and pressed ok, it will show all employees having “Abraham” as first name as shown below.
Example 2: (Filter using wildcard techniques)
- Using SQL Server Management Studio(SSMS):
In SSMS, we use WHERE clause in order to filter the data as shown below.
USE AdventureWorks2019
GO
SELECT EmailAddressID
, EmailAddress
, ModifiedDate
FROM Person.EmailAddress
WHERE EmailAddress LIKE 'Kendra0%' OR EmailAddress LIKE 'kendall0%';
GO
--OUTPUT
- Using Azure Data Studio:
Step 1:
First of all, you need to write a query without WHERE clause and run it. After that, you just need to click on show filter button as highlighted below and it opens up the filter window.
Step 2:
In this step, you just need to select the respective value which you want to filter. Since I selected EmailAddress “kendra0% ” or “kendall0%” and pressed ok, it will show all EmailAddresses having “kendra0% ” or “kendall0%” as EmailAddress as shown below.
Conclusion:
I use Azure Data Studio for filtering the data and found it quite helpful and hassle free. Do let me know if you use it.
SQL Server Portal 