If you want to update from one table data to another table you can easily inner join the table by the same id key field and set the table the alias to perform the update.

Need to delete all the user creation views in TSQL? You can easily delete the views using the while loop method against the sysobjects table.

If you need to delete all the user creation stored procedure in SQL server database. You can use the following TSQL code snippet.

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.

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.

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.

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.

Learn how to get the last of the month in TSQL.

Learn how to get the current UTC date time in TSQL using the built-in function named GetUTCDATE.

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.