SQL Server单元测试:可以在“预测试”脚本中创建临时表，并在主测试中使用它们吗?

I am an SQL newbie trying to create unit tests for stored procedures in a legacy database. The stored procedures retrieve input data from temporary tables, which seems like it would make it easy to test them. I would like to create and populate those tables in a test harness setup routine, run the stored procedure, and then evaluate the results.I am an SQL newbie trying to create unit tests