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 vote227 views1 answer
Sql server remove enter from string
SQL
0 vote227 views1 answer
Sql server split string and insert into table select
SQL
0 vote235 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote244 views2 answers
Psql commande \gset
SQL
0 vote220 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote240 views1 answer
Mariadb select limit offset
SQL
0 vote228 views1 answer
Number(10 2) in sql means
SQL
0 vote226 views1 answer
Sql database size
SQL
9 votes236 views4 answers
Last mysql
SQL
0 vote226 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL