Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.
COURSE of the MONTH
15 days, 4 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.
Active today
>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 today
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
Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month15 days, 4 hours left to enroll
771 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.