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 vote209 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote238 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote189 views1 answer
SQL Server format datetime
SQL
1 vote216 views1 answer
Sql server update column based on another table
SQL
0 vote204 views1 answer
Sql show all users
SQL
0 vote184 views1 answer
Oracle list chain steps
SQL
8 votes193 views2 answers
Select table column name in sql
SQL
0 vote251 views2 answers
How to install psql in ubuntu
SQL
5 votes232 views3 answers
Db begintransaction laravel
SQL
-1 vote293 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL