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

2 votes187 views1 answer
Show max_allowed_packet mysql
SQL
0 vote133 views1 answer
The local psql command could not be located
SQL
0 vote147 views1 answer
Postgresql conectar
SQL
3 votes146 views1 answer
How to find names includes in sql
SQL
0 vote154 views1 answer
Extract sql from query object sqlalchemy
SQL
1 vote137 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote151 views1 answer
On sql table data exists
SQL
0 vote131 views1 answer
Oracle DROP PROGRAM
SQL
2 votes156 views2 answers
Storing timezones in postgres
SQL
1 vote145 views1 answer
Spark sql concatenate string and int
SQL