复制数据库中的所有表并添加新数据，而不会影响旧数据SQL

Can anyone help me with a stored procedure that would allow all the tables in a database to be copied and the original tables must be truncated at the end, and when the procedure runs everyday all new data must be copied from the original table to the backup tables without affecting the existing data. Can anyone help me with a stored procedure that