Transact-SQL (T-SQL)

Using condition inside COUNT() in SQL Server is simple and comes in handy when you cannot use WHERE clause in the select statement.

Here is a simple method which I use to get the sizes of all databases on SQL Server in a single list.

Here is a simple tip to get the list of user created databases in an SQL Server.

As a database programmer, you may need to get result in table format from a stored procedure and store it to a temp table. Here we will see how to insert results from Stored Procedure to a temp table.

Here are the simple steps with example for altering existing version tables with data to system-versioned temporal table.

Using simple sql technique, here we will see how to get the list of temporal tables in a database.

How to check and drop a system-versioned temporal table if it exists in the database as temporal tables are different from regular tables?

Here a simple trick to find the name of the history table of a system versioned temporal table using SQL select statement.

Let us see how to check if a specific table is system versioned temporal or not using SQL script. SQL tips to check if temporal table exists.