sql cursor problem

Results 1 to 2 of 2

Thread: sql cursor problem

  1. #1
    Join Date
    Dec 1969

    Default sql cursor problem

    ok so its not asp .. but there are no good sql forums out there,<BR>and lets face it, it will be a change for us all to do some sql<BR>.... <BR> so how do i do an insert statement to move a number of rows <BR>from table &#039source&#039 into table &#039destination&#039, the update is easy <BR>but the insert, well im defeated to be honest

  2. #2
    Join Date
    Dec 1969

    Default RE: sql cursor problem

    im not sure i understand your question, wouldnt it just be...<BR><BR>insert into dest_table<BR>(<BR>columns)<BR>select columns from source_table<BR><BR>after dest table is appropritely defined. sounds to simple, i probably misunderstood

Posting Permissions

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