Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • SQL Server Like operator August 3, 2022
  • Using dbatools to find orphaned files July 6, 2022
  • SSMS: Saving changes is not permitted error June 7, 2022
  • SQL Server: TableSample clause May 4, 2022
  • T-SQL: Create a running total April 6, 2022
August 2022
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Jul    

Tag: backup table

How to copy data into a backup table

Before you update or delete data from a table, it is always a good idea to make a backup just in case.  Using the INTO clause in your sql statement, allows you to do this.

Continue reading How to copy data into a backup table

Posted on July 17, 2017June 11, 2017Categories Hints and TipsTags backup table, copy table, select intoLeave a comment on How to copy data into a backup table
Create a website or blog at WordPress.com
  • Follow Following
    • Jim Salasek's SQL Server Blog
    • Join 27 other followers
    • Already have a WordPress.com account? Log in now.
    • Jim Salasek's SQL Server Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar