Everything you need to know about backup and disaster recovery with AWS, for FREE!
Course Of The Month
5 days, 20 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Query about SELECT INTO copying table
Posted on 2014-02-06
Hi,
If I copy a table using SELECT * INTO xyz from abc, then would that new table XYZ fetch new rows when old table ABC will be updated?
Or any other method to create a copy and it gets automatically updated?
If I copy a table using SELECT * INTO xyz from abc, then would that new table XYZ fetch new rows when old table ABC will be updated?
Or any other method to create a copy and it gets automatically updated?
[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
2-
2
- +1
6 Comments
Active today
>would that new table XYZ fetch new rows when old table ABC will be updated?
No. It's a single action, and once it's complete there is no relationship / connectivity between xyz and abc.
>Or any other method to create a copy and it gets automatically updated?
Explain your needs to us, and we'll propose something.
No. It's a single action, and once it's complete there is no relationship / connectivity between xyz and abc.
>Or any other method to create a copy and it gets automatically updated?
Explain your needs to us, and we'll propose something.
>Or any other method to create a copy and it gets automatically updated?
You need to create insert/update triggers for this ..
You need to create insert/update triggers for this ..
I have a table ABC. One column in ABC needs to be updated for the purpose of creating report. So I cannot make update on ABC.
ABC is a live table, so it keeps updating.
Can I create a procedure? Can you show me how?
Thanks everyone for your replies.
ABC is a live table, so it keeps updating.
Can I create a procedure? Can you show me how?
Thanks everyone for your replies.
Active today
>One column in ABC needs to be updated for the purpose of creating report.
Spell this out for us, as in most companies updating a production table to reflect anything dealing with reporting is bound to get you some unwanted attention.
Spell this out for us, as in most companies updating a production table to reflect anything dealing with reporting is bound to get you some unwanted attention.
Active 1 day ago
Create a separate reporting table, for example "ABC_Report_Data", with the key column(s) from table ABC. Put your new data column(s) in that table. You can join to/from ABC using the key column(s).
For example:
CREATE TABLE dbo.ABC (
key_col int ...,
data_col1 ...,
data_col2 ...,
...
)
CREATE TABLE dbo.ABC_Report_Data (
key_col int ..., --FK --> dbo.ABC ( key_col )
report_col ...
)
For example:
CREATE TABLE dbo.ABC (
key_col int ...,
data_col1 ...,
data_col2 ...,
...
)
CREATE TABLE dbo.ABC_Report_Data (
key_col int ..., --FK --> dbo.ABC ( key_col )
report_col ...
)
Featured Post
How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article.
SARGable is an adjective in SQL that means that an item can be fou…
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Course of the Month5 days, 20 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
707 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.