Results 1 to 7 of 7

Thread: transfering data from one table to another table

Hybrid View

  1. 08-16-2007, 09:33 AM #1
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    How are you transferring it? Did you use

    INSERT INTO tableB
    SELECT FROM tableA

    If it fails then you get an error, otherwise it succeeded. You can check the row count on tableB.
    Reply With Quote Reply With Quote
  2. 08-16-2007, 09:35 AM #2
    nisha
    nisha is offline Registered User
    Join Date
    Oct 2006
    Posts
    9
    No By triggers we transfer from one table to another. Is there any way to transfer the data from one table to another.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules