Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.
Solved
Make a backup of a SQL Server table
Posted on 2013-12-02
I created a backup table named StockHistBak by copying the structure of StockHist.
How to I populate StockHistBak from the data in StockHist?
Thanks,
How to I populate StockHistBak from the data in StockHist?
Thanks,
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
5 Comments
Active 7 days ago
If it's a one off, drop it and do this:
select * into StockHistBak from StockHist
If it's something you want do do regularly, create a maintenance task to drop and recreate it sing the above code.
select * into StockHistBak from StockHist
If it's something you want do do regularly, create a maintenance task to drop and recreate it sing the above code.
Active 7 days ago
If you don't want to drop the table, then use something like this:
insert into StockHistBak
select * from StockHist
insert into StockHistBak
select * from StockHist
Active today
via TSQL:
INSERT INTO StockHistBak
SELECT * FROM StockHist
If you have Identity column on the table then you have to use SET IDENTITY_INSERT StockHist ON and Off before and after the statements along with column list instead of * to get it work.
INSERT INTO StockHistBak
SELECT * FROM StockHist
If you have Identity column on the table then you have to use SET IDENTITY_INSERT StockHist ON and Off before and after the statements along with column list instead of * to get it work.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I have a large data set and a SSIS package. How can I load this file in multi threading?
Windocks is an independent port of Docker's open source to Windows. This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
- SQL
- Microsoft SQL Server
- AWS
- Azure
- Docker
- *DevOps
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses
Course of the Month4 days, 17 hours left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.