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

-2 votes197 views1 answer
Trunc in sql
SQL
1 vote148 views1 answer
Mysql count multiple columns in one query
SQL
0 vote154 views1 answer
Install squirrel sql ubuntu
SQL
0 vote148 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
1 vote139 views1 answer
Mysql select row max date
SQL
1 vote147 views3 answers
Sql union
SQL
2 votes147 views1 answer
Add default sql server
SQL
1 vote152 views2 answers
Mysql update table from another table
SQL
3 votes150 views2 answers
Tsql join multiple record in one string
SQL
0 vote139 views1 answer
Do postgresql
SQL