SQL Query to Copy and Insert a Record from Same Table

Published by: San (2/6/2008)

I have an asp file where I have to copy few rows from a table and insert in the same too. I don’t want to make 2 queries by reading through the first then insert through the second query. If you know any way by which I can make a read and write in the same query then please post your comment.

 

Most Popular Articles

• How can I run my Stored Procedure in SQL Server 2005
• SQL Join Query for Microsoft Access Database
• What is the use of nolock condition in SQL Query
• when to use cast and when to use convert operator in SQL
• How can I Truncate my Database Log to Reduce the Size

How to Export and Import Data from SQL Server through a Text File >>

<< SQL Join Query for Microsoft Access Database