how do I INSERT data into multiple tables at once?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • varunkumarid
    New Member
    • Aug 2008
    • 40

    #1

    how do I INSERT data into multiple tables at once?

    Hai to one and all...
    I want to check the SQL server2000 Database Table Exist or not..
    I am using the VB.NET 2005 Version
    I dont know how to solve this problem.....
    If you this one solution please inform quickly...
    Thank you
  • cloud255
    Recognized Expert Contributor
    • Jun 2008
    • 427

    #2
    This is a very confusing thread, your title seems to have nothing to do with your actual question. But i suggest you use metadata from the SQL server:

    Code:
    select * from yourDB.information_schema.tables
    This will return all the tables in the database along with various other data, play with it and see if this solves your problem.

    Again, please follow the guidelines when posting.

    Comment

    Working...