Understanding SQL Server ALTER TABLE ADD COLUMN Statement
This article describes the SQL Server ALTER TABLE ADD COLUMN statement. The purpose of this...
SQL DROP TABLE Statement and Various Use Cases
The SQL DROP TABLE statement serves to drop the table from the database. It removes the table and its data and indexes associated with it....
How to Parse Strings Like a Pro Using SQL SUBSTRING() Function?
Do you enjoy parsing strings? If so, one of the indispensable string functions to use is SQL SUBSTRING. It is one of those skills a...
A Practical Use of the SQL COALESCE Function
This article talks about the practical use of the SQL COALESCE function regarding some professional...
Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners
This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values....
Views in SQL Server
Introduction A view in SQL Server is a virtual table-like structure based on the result-set of an SQL statement. On the surface, a view is...
Top Answers to 5 Burning Questions on COALESCE Function in SQL Server
How cool is COALESCE function in SQL? It’s cool enough to be so important to me. And I’ll be...
Workplace Encounters: Reclaiming Space from an Oversized Database
INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd...
Analytic Functions in SQL Server
Aggregate and Analytic functions in SQL Server operate on a set of rows. However, unlike such aggregate functions as sum, count and average...
Ranking Functions in SQL Server
Suppose you are designing an SQL Server database application for a company’s CEO and you have to...
