Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Query about SELECT INTO copying table
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?
Asked:
2-
2
- +1
2 Solutions
>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.
>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.
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 ...
)
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
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.