How to create table in TSQL?

How to create table in TSQL?

Learn how you can easily create a table using a TSQL query. We are going to perform a quick check if a table that we are going to create does not exist in the database. This is to ensure we do not get any errors.
How to drop a table in TSQL?

How to drop a table in TSQL?

If you need to delete a table in TSQL using a code query. You firstly need to check if the table exists in the database. This will ensure you will only delete the table if it exists.
How to rename a table in TSQL?

How to rename a table in TSQL?

If you want to rename a table in TSQL. We can use the built-in function called sp_rename. This function will accept two parameters string. The first one will be the table name that you want to rename. The second parameter string will be the new table name.
How to declare table variable in TSQL?

How to declare table variable in TSQL?

In this tutorial, we are going to learn how to declare a table in TSQL. We are going to insert some records into this table and perform some query selection against it.
TSQL Between

TSQL Between

The TSQL Between operator function is used to return results based on comparing between two expression values. Those expression values are in numbers or date format.