how do I INSERT data into multiple tables at once?

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

    how do I INSERT data into multiple tables at once?

    hai to one and all...

    I am using The VB.Net 2005 and SQL server2000 ..

    I need to insert the Data into multiple tables at once...

    if you know about this Concept please Reply quick
  • PRR
    Recognized Expert Contributor
    • Dec 2007
    • 750

    #2
    Originally posted by varunkumarid
    hai to one and all...

    I am using The VB.Net 2005 and SQL server2000 ..

    I need to insert the Data into multiple tables at once...

    if you know about this Concept please Reply quick
    strored proc is the way to go... for better control n security....
    Check this

    Comment

    Working...