Copy rows generator

This stored procedure is created from the need to copy rows from a table with new value. The script itself will create stored procedure proc_copyrows.
The parameters are
@TableName: the table name
@FilterField: filter field, default is null, means no filter
@SourceValue: the value of filter field from source data to be copied
@DestinationValue: the new value of filter field
@SourceDB: the source database, please add '..' at the end, such as 'pubs..'

Only @TableName is mandatory
The result is the SQL INSERT statement that can be copied and executed.

Enjoy yourself!