If you need to truncate a table content in TSQL. You can use the built-in function called TRUNCATE.

In this article, we going to learn how to update a table with join another table in SQL Server.

If you have a database backup bak file extension and want to restore it using SQL query You can use the built in RESTORE DATABASE function Remember in order to be able to restore a database successfully You need to ...

If you need to back up a database using SQL query in SQL Server. You can use the built-in function called 'BACKUP DATABASE'.

To get the information about how much space or size used by tables You can retrieve the size information by linking multiple tables in sys tables There are two tables that hold this information The first one is the sys ...