Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: Update multitable Query?

    Is there a way to update a multi-table query in SQL Server?

  2. #2
    Join Date
    Sep 2003
    Assen, Nederland

    Yes, Views

    multi table query = view which is a virtual table in itself and is updatable.

    So make a view and then test it in your test env wrt pk,fk and other dependencies...
    Hope that helped...
    Visit My Website :
    Tarry Singh

    OCP DBA 8i
    Currently: SQL Server DBA 7,2000
    Oracle, PHP Programmer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts