Good morning. How can I automatically update a table through a view in SQL server

Question

1.00/5 (1 vote)

See more:

Good morning.I have view in my database.
I need this view to run automatically, and update a table with the new data.
It's possible? how can i do it?
thank you very much for your help

What I have tried:

I tried several things I researched, but none of them worked.

Posted 20-Jul-22 21:31pm

miguel santos 2021

Updated 21-Jul-22 2:09am

Add a Solution

Comments

Richard MacCutchan 21-Jul-22 4:30am

A view is a dynamic representation of some part(s) the database. It can only display data, not change it.

miguel santos 2021 21-Jul-22 4:42am

Thank bro, but there's ny way i can do this?

Richard MacCutchan 21-Jul-22 4:48am

No. You are asking how to change the wheel on a car by looking at a picture of the car.

miguel santos 2021 21-Jul-22 4:55am

thanks again.
I asked this question because I'm new to sql.
And in a previous topic, I asked for help to create a field calculated with subtraction in a view.
As they couldn't help me, I thought of using view to create and update a table, and make the calculated field in that table

Richard MacCutchan 21-Jul-22 5:17am

If you are new to SQL (and any other tchnology) then rather than trying to guess things, make use of some of the excellent tutorials which will help you to understand what is, and is not, possible. The one I use most often is at SQL Tutorial[^].

CHill60 21-Jul-22 6:06am

You were given some very sound advice on your earlier question. It is incredibly difficult to answer questions of this type without a description of the table, some sample data and your expected results - it helps to overcome problems with the English language too

Maciej Los 21-Jul-22 8:08am

Sorry, Richard, but you're wrong. It is possible to update data through the view, but it is needed to make extra job.

Richard MacCutchan 21-Jul-22 8:15am

Thanks, I was not aware of that.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2022-07-21T02:09:00

Solution 1

Well, a possibility to change data through view depends on database provider...

SQL Server: Modify Data Through a View - SQL Server | Microsoft Docs[^]
MySQL: MySQL :: MySQL 8.0 Reference Manual :: 25.5.3 Updatable and Insertable Views[^]
Postgres: PostgreSQL Updatable Views[^]

Posted 21-Jul-22 2:09am

Maciej Los

Updated 21-Jul-22 2:14am

v2

Comments

CHill60 21-Jul-22 8:14am

My 5. I was with Richard, thinking it cannot be done. I have learned something new today - thank you

Maciej Los 21-Jul-22 9:27am

Thank you, Caroline. :)