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 vote105 views2 answers
Sql select inside select
SQL
0 vote110 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote104 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
31 votes111 views2 answers
Grant all priviledges to mysql user
SQL
0 vote102 views1 answer
Sql find leading space
SQL
3 votes95 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote112 views2 answers
Replace null with 0 in sql
SQL
0 vote99 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote110 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote118 views1 answer
Mysql insert multiple rows based on select
SQL