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!

Register Log in
  • Congratulations strongm 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

HenryE

IS-IT--Management
Apr 30, 2002
42
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
 
Sort by date Sort by votes
Take a look at BOL under "views-SQL Server, updatable"

Thanks

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

Henry
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

csharpenthusiast007
  • Locked
  • Question
create view on a reporting database by searching for specific views on many different DWH database
Replies
1
Views
42
johnherman
johnherman
davism
  • Locked
  • Question
DDL to files for DB artifacts (Stored Procedures, Views, Triggers, etc) in a SQL Server DB. 1
Replies
1
Views
59
TamarGranor
TamarGranor
NAMARA
  • Locked
  • Question
hiding Tables,Views,Procedures in MsAccess project
Replies
1
Views
39
softhemc
softhemc
sds814
  • Locked
  • Question
disadvantage of views? 1
Replies
12
Views
70
gmmastros
gmmastros
wbodger
  • Locked
  • Question
Queries and views
Replies
8
Views
48
wbodger
wbodger

Part and Inventory Search

Sponsor

Back
Top