This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.
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?
Who is Participating?
>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.
All Courses
From novice to tech pro — start learning today.
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.