From table to table.

Results 1 to 2 of 2

Thread: From table to table.

  1. #1
    Conrad Guest

    Default From table to table.

    What would be the method(syntax) for copying a set of data from one table to another using a stored procedure?<BR>I am using Windows2000 and SQL Server 7.<BR><BR>Thnaks for your help,<BR>Conrad

  2. #2
    Join Date
    Dec 1969

    Default RE: From table to table.

    CREATE PROCEDURE spName<BR>@pCriteria varChar(10)<BR>AS<BR>INSERT INTO TableNameTo (FieldList) <BR>SELECT FieldList FROM TableNameFrom<BR>WHERE SomeField = @pCriteria<BR><BR>FieldList is a comma delimited list of field names ...<BR><BR>HTH

Posting Permissions

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