Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
how to Update a view in Sql Server
October 11, 2010
Please guide me step by step on how to update a view in sql server...
Posted Date: October 13, 2010 Points: 5
Step1: Create two tables TableA and TableB with your own columns
Step2: Create a view using the query
SELECT * FROM TableA
Step3: Modify the view using query
ALTER VIEW MyView AS SELECT * FROM TableB
In this example the view "MyView" was updated on executing Step3. Hope this would provide the answer :)
Posted Date: October 30, 2010 Points: 5
We can update a view If it is created from a single table.
SET [empid] = <empid, int,>
,[empname] = <empname, varchar(50),>
WHERE <Search Conditions,,>
We have to use instead of trigger to update a view If it is created from multiple table.
To post reply
Related Questions Related Questions
Can we update a View in Sql server?
Can we update the data in a view?
update grid view row
update grid view''s row
How to know user name who have update table using SQL Server
How to copy a file from server to local system
To save image in the SQL server.
images in grid view
Image store in Database SQL SERVER
how can we update database thru datagrid
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend