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 vote110 views1 answer
Sql convert float to string
SQL
5 votes114 views1 answer
Mysql change primary key
SQL
0 vote120 views1 answer
How many columns can be used for creating index?
SQL
1 vote121 views2 answers
Sql drop multiple columns if exists
SQL
0 vote114 views1 answer
Ora 00001 error catch plsql
SQL
13 votes115 views2 answers
Mysql order by multiple columns
SQL
25 votes133 views1 answer
How to update an attribute in MySQL
SQL
0 vote120 views1 answer
Copy data from one postgres container to another
SQL
7 votes142 views1 answer
Oracle alter sequence restart start with
SQL
0 vote134 views1 answer
Sql out file formate
SQL