Category Archives: Uncategorized

Have you ever wanted to search for a column for a range of values? For example if you were searching for Product ID which ranges from 1 to 300, or look for a range of names starting A to D. Well I can show you how to do these quickly and easily by using theContinue reading “Use SQL to search a column for a range of values — Parv The IT Geek”

Have you ever been presented with a list of values which need to be found in a column or wondered how to search for a list of exact names, addresses, numbers without using wildcard searches or ranges. Well SQL has the answer and it is the IN command. USE AdventureWorks GO SELECT * FROM HumanResources.DepartmentContinue reading “Search for a list of values using the IN command in SQL — Parv The IT Geek”

Well SQL has the solution and our saviour is the ‘IS NULL’ and ‘IS NOT NULL’ commands. Using them in a ‘WHERE’ clause will allow us to do the filtering out appropriately. USE AdventureWorks GO SELECT COUNT(*) FROM [AdventureWorks].[Person].[Address] The above query bring us a result of 19,614 rows contained within the AddressLine2 where noContinue reading “NULL Values — How to filter out NULLS and how to find NULLS using SQL — Parv The IT Geek”

A basic query of the HumanResources.Department table bring s the following results. If you wanted to reverse the order of the DepartmentID then you would need to user the ‘ORDER BY’ clause. The default sort is always ascending ( ASC) but it does not have to be explicitly written. If you want the order toContinue reading “How to order results in SQL? ORDER BY — Parv The IT Geek”