Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL
You have mentioned that complex views do not support DML operations and used a Term *At A Time*. I have created a view called vTestParentChild which consists of a select query having join of two tables TableParent and TableChild and when I perform update operation like update vTestParentChild set ParentName = 'P1' where ParentId = 1 and *it's being updated*. So it's confusing.
using CREATE OR REPLACE VIEW you can modify the view definition. EG: CREATE OR REPLACE VIEW emp_view AS first_name, last_name , department_number[new column] FROM employees;
Sir Apny View Ka Use To betaya hey.. Lkn View Q benaty hey Hum Jabkey Hamny Aik Table Benaya Howa Heyna Sir .... View Kis Waja Se use Kya Jata Hey.... Ye Basic Ager Ap Samjhty Sir ...It Was Good For Me And us...........
Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL
Sir decision making statements in sql server video available or not sir ???
sir!
your teaching is so good,well i am easily to understand based on your explination...
thank you so much...sir
Thank you so much sir.... Your way of teaching is Exalent sir.
Thank you sir for sharing your knowledge. You make easy to understand SQL DBA
Thanks Naresh. You are the best
Superb sir chala baga cheparu
Great Tutorial, thankyou bro..
Very nice sir excellent explanation
Wow superb video..I learned very easily...sir did u upload any video for stored procedures
Ur teachings r ausm Sr provide videos for oracle also plz
Excellent explanation Anna please make a video on triggers...
AMAZING.. THANKU SIR..
Great job on this video👌
Excellent ...
We need practice work of SQL server and some live project topic explanation
Thank you sir
Simple and sweet .....
You have mentioned that complex views do not support DML operations and used a Term *At A Time*. I have created a view called vTestParentChild which consists of a select query having join of two tables TableParent and TableChild and when I perform update operation like update vTestParentChild set ParentName = 'P1' where ParentId = 1 and *it's being updated*. So it's confusing.
Thankyou sir
Hi Naresh IT, Please Update video Materialised view in SQL server Example. Thank You
how to add a new column to the table thorugh view????????????????
using CREATE OR REPLACE VIEW you can modify the view definition.
EG: CREATE OR REPLACE VIEW emp_view AS first_name, last_name , department_number[new column] FROM employees;
Yes
Sir in sql prompt its comes to insufficient privileges.
How can we know the base table name if we know only the View Name? i mean i know only View name but i also want to know the corresponding table name
Sir Apny View Ka Use To betaya hey.. Lkn View Q benaty hey Hum Jabkey Hamny Aik Table Benaya Howa Heyna Sir .... View Kis Waja Se use Kya Jata Hey.... Ye Basic Ager Ap Samjhty Sir ...It Was Good For Me And us...........
Speak English ! @Justice of Voice
Ek baat ktni baar bolega bhai ??? Ek e bar me smjh aa jata ha
Bhai sb apki tarah intelligent ni hote .