tag:blogger.com,1999:blog-6082652835152798567.post8144831229371754727..comments2024-03-28T00:58:12.736-07:00Comments on Sql server, .net and c# video tutorial: Updateable Views - Part 40Unknownnoreply@blogger.comBlogger16125tag:blogger.com,1999:blog-6082652835152798567.post-2341011356846645042021-08-12T04:29:21.035-07:002021-08-12T04:29:21.035-07:00Awesome content. No one explains it so accurately ...Awesome content. No one explains it so accurately with such good example!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-71010019702541143782020-12-09T03:49:34.498-08:002020-12-09T03:49:34.498-08:00Hi vitalreddy, you can use schemabinding option wi...Hi vitalreddy, you can use schemabinding option with view to prevent dependent tables from altered. You can view in more detail in next part.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-10607822005161392772019-09-20T03:59:25.898-07:002019-09-20T03:59:25.898-07:00DELETE from vwEmployeeDetailsByDepartment where Na...DELETE from vwEmployeeDetailsByDepartment where Name = 'IT'<br />Msg 4405, Level 16, State 1, Line 9<br />View or function 'vwEmployeeDetailsByDepartment' is not updatable because the modification affects multiple base tables.Saudagar Jadhavhttps://www.blogger.com/profile/06718390151619886715noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-84345617713771020362019-09-20T03:57:46.983-07:002019-09-20T03:57:46.983-07:00No.
INSERT INTO vwEmployeeDetailsByDepartment(Id,...No.<br /><br />INSERT INTO vwEmployeeDetailsByDepartment(Id,Name,Salary, Gender, DeptName) VALUES(7,'Sam',6000,'Male','New')<br />Msg 4405, Level 16, State 1, Line 9<br />View or function 'vwEmployeeDetailsByDepartment' is not updatable because the modification affects multiple base tables.Saudagar Jadhavhttps://www.blogger.com/profile/06718390151619886715noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-10346678589050739442019-07-14T07:10:40.244-07:002019-07-14T07:10:40.244-07:00It will be NULLIt will be NULLRanveer Singhnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-91585759526710068382019-04-13T08:14:20.584-07:002019-04-13T08:14:20.584-07:00Sir we have done update query vWEmploteeesDataExce...Sir we have done update query vWEmploteeesDataExceptSalary , but is it possible to do Insert Record in tow Table...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-54357611446435456352019-01-21T02:35:33.104-08:002019-01-21T02:35:33.104-08:00Venkat Sir, Thank you very much for your videos. I...Venkat Sir, Thank you very much for your videos. In this video of PART-40 Updatable views in SQL server at 5:05 in this video when we execute <br />Insert into vWEmploteeesDataExceptSalary values (2, 'Mikey', 'Male',2) the values has inserted but what about the Salary field of Mikey, we have not supplied any value to that field, So it may get NULL or any other value? M A BASHAhttps://www.blogger.com/profile/14060970416115351289noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-5484634138525954322018-01-27T23:35:52.455-08:002018-01-27T23:35:52.455-08:00view can be update then why we use instead of trig...view can be update then why we use instead of triggerRamendra kumarhttps://www.blogger.com/profile/00401569605522505217noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-81430469602145278402018-01-27T23:35:01.017-08:002018-01-27T23:35:01.017-08:00view can be update then why we use instead of trig...view can be update then why we use instead of triggerRamendra kumarhttps://www.blogger.com/profile/00401569605522505217noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-13677755003005069382018-01-24T21:50:08.666-08:002018-01-24T21:50:08.666-08:00THANKS! THANKS! Ramzan Alihttps://www.blogger.com/profile/11579655227323496896noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-42424439426229448362017-09-20T10:17:05.012-07:002017-09-20T10:17:05.012-07:00Thanks Sir for such well explanatory videos
Today ...Thanks Sir for such well explanatory videos<br />Today i attended an interview and i was asked if we have index on views and we need to update that view, then should we update the view after dropping index or not?<br />I am not sure of this answer , it will be great if you can explain it with exapmles<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-35501002200686538962016-07-09T09:02:07.548-07:002016-07-09T09:02:07.548-07:00Hi Vitalreddy,
Venkat already explained this for ...Hi Vitalreddy,<br /> Venkat already explained this for functions.<br />same can be applied here for view as well. I mean schema binding.<br /><br />alter view vWEmployeesByDepartment<br />with schemabinding<br />as<br /><br />select Id, Name, Salary, Gender, DeptName from dbo.tblEmployee E <br /><br />join dbo.tblDepartment D <br /><br />on D.DeptId = e.DepartmentId <br /><br />when you use shcemabinding your objects must containe 2 part names like dbo.tblEmployee<br />Anonymoushttps://www.blogger.com/profile/06321465681611065725noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-77509151682318168912016-04-23T03:37:24.616-07:002016-04-23T03:37:24.616-07:00You will have to give the permissions to the table...You will have to give the permissions to the tables to not update by the others.Anonymoushttps://www.blogger.com/profile/17712607824599402044noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-10085138027618564632014-10-22T06:02:45.250-07:002014-10-22T06:02:45.250-07:00Sir i like your videos, i am following you..i have...Sir i like your videos, i am following you..i have some doubt ,is it possible update ,delete ,insert on views it contains more tables? incase there is a chance how to do that? another one ..if changed columns data on views it getting effecting on base table so it is good or bad? if bad how to prevent that one.. another one .. i created view but some one changed my original table then view was effected so how to stop others didn't change base table data until my permissions...vitalreddyhttps://www.blogger.com/profile/05057660348660342103noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-57428479247205972442014-07-18T21:03:57.412-07:002014-07-18T21:03:57.412-07:00An Update statement with View can effect on tabl...An Update statement with View can effect on table data??Anonymoushttps://www.blogger.com/profile/00227575055252672886noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-59645554855256626322013-11-21T06:24:44.341-08:002013-11-21T06:24:44.341-08:00Sir, I an great fan of your videos. I have learnt ...Sir, I an great fan of your videos. I have learnt so many things from it.<br />I am very much thankful to you.<br />Could you please explain what will happen when updating a computed column(e.g. calculated,decrypted)<br />in a view?<br />ThanksAnonymousnoreply@blogger.com