t-sql
SQL SELECT Statement
SQL SELECT is probably the most widely used SQL statement. That's why we have decided to investigate options that can be used in the query.
How to Create, Update, and Drop Views in PostgreSQL
The definition of a view in PostgreSQL—and in other SQL database management systems, for that matter—is rather simple: a view is a virtual table...
SQL EXISTS or NOT EXISTS, That Is the Question
The article provides a detailed overview of the T-SQL IF EXISTS and NOT EXISTS statements. It also explains why EXISTS should be chosen over...
How to Create Login, User, and Grant Permissions in SQL Server
In the article, we are going to examine how to create a new user account and grant/revoke permissions and roles on a database object,...
SQL INSERT INTO Statement – Overview with Examples
The article presents a step-by-step guide to SQL INSERT INTO statement. You will learn the basic principles underlying this command and see how to...
How to Create Customizable CRUD Operations with SQL Complete
Working with SQL databases and tables usually implies performing daily data-related tasks using the CRUD operations in order to re-use, manipulate, and access data...
Introduction to SQL Server Temporary Tables
We all need to refer to temporary tables quite often. They are necessary to deal with interim aggregations or outputting intermediate results. However, it...
Restore SQL Server Database Backup Using T-SQL Script and SSMS
The third article in the series about SQL Server backup and restore will take us through the database restore process and demonstrate the two...
