Saturday, December 5, 2015

Can we write delete update and insert statement on view in sql server

Yes we can write the delete,insert and update query on view.
if we are creating a view using single table then we can write all delete,insert and update query.but when we are using multiple table in view we can not write select,update and delete query.

No comments:

Post a Comment

Find the value from array when age is more than 30

 const data = [   { id: 1, name: 'Alice', age: 25 },   { id: 2, name: 'Bob', age: 30 },   { id: 3, name: 'Charlie', ...