Backup a table using T-Sql in MsSql
I just wanted to share a short code snippet to help you backup a table using T-Sql in MsSql.
It is very useful if you are working with vital data and do not want it to be ruined. Or you may want to guarantee the latest version of the database.
SELECT * INTO BackupTableName FROM NameOfDataBaseTableToBackup
NameOfDataBaseTableToBackup represents the name of database table to be backed up.
BackupTableName represents new table that will contain the table data to be backed up.
Hope it helps!