Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updatable Multitable Views?

Status
Not open for further replies.

HenryE

IS-IT--Management
Apr 30, 2002
42
0
0
US
Anyone know how to create updatable multitable views in SQL Server 2000?

Actually, I was able to do just that for a view with two tables. However, I have been unable to do it for a view with more tables, or for a view that combines a table and another view (the one based on the two tables).

Thanks.

Henry
 
Take a look at BOL under "views-SQL Server, updatable"

Thanks

J. Kusch
 
Thanks for the tip. The view works fine now.

Henry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top