Sql server backup table

SELECT * INTO BackupTable FROM Table

Backup table mssql

declare @name varchar(100) = 'tableName'

declare @timestamp varchar(100) =  
 replace(cast(convert(varchar, getdate(), 126) as varchar(10)), '-', '') + '_' 
 + RIGHT('00' +cast(datepart(hour, getdate()) as varchar), 2)
 + RIGHT('00' + cast(datepart(minute, getdate()) as varchar), 2) + '_' 

declare @query varchar(MAX) = 'select * into backup_' + @timestamp + @name  + ' from ' + @name

--select @query
exec(@query)

-1

Similar codes

0 vote120 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote127 views1 answer
Trim leading zeros in sql
SQL
0 vote129 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote142 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote121 views1 answer
Sql dmv to capture updates
SQL
0 vote123 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
19 votes116 views6 answers
Laravel sql query
SQL
0 vote118 views1 answer
Oracle current timestamp
SQL
-1 vote152 views4 answers
Full outer join in sql
SQL
1 vote111 views1 answer
Cross schema query oracle 2 users
SQL