Backup table mssql

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 vote345 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote340 views1 answer
How to get employee having maximum experience in mysql
SQL
1 vote368 views1 answer
Update from select oracle
SQL
3 votes364 views1 answer
Apex set debug level
SQL
18 votes350 views3 answers
Mysql query add column with default string value
SQL
1 vote523 views1 answer
Postgres upgrade to superuser
SQL
0 vote383 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
5 votes366 views2 answers
Sql server port number
SQL
-1 vote343 views1 answer
Add column alter table default value
SQL
0 vote317 views1 answer
Mysql sleep connections
SQL