SQL Aggregate Functions: Easy Tips for Newbies
SQL Aggregate Functions are functions that perform calculations and return a summarized...
User-Defined Data Types In SQL Server
SQL Server platform comes with many data types, but there are cases when they are not sufficient. Or, custom data types could help make...
SUBSTRING Command in SQL: A Primer
Similar to my article regarding the SQL Server STUFF command, today we will be examining the SUBSTRING SQL server command. It is similar to...
Getting Started with the SQL Server T-SQL CASE Expression Statement
SQL Server CASE expression is very useful in returning an output based on some conditional matching...
SQL Server Primary Key
Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the records present in a table uniquely....
SQL Server Triggers – Part 2 DDL & LOGON Triggers
In SQL Server, triggers are database objects which will get executed whenever a triggering event happens on the database or server....
SQL Server Triggers: DML Triggers
In SQL Server, triggers are database objects which get executed whenever a triggering event happens...
What is SQL Server? (Definition, Versions, Editions)
Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit overwhelming. You have lots of questions. You...
How to Read and Interpret SQL Errors
Error codes in SQL are generated by the server to provide information about what has gone wrong. They have different meanings depending on...
User-Defined Functions in SQL Server
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of....