How can I create two temporary tables with the same structure without write twice?
Something like that:
DECLARE @TEST_TABLE1, @TEST_TABLE2 TABLE
(
FIELD1 INT,
FIELD2 INT
)
and NO:
DECLARE @TEST_TABLE1 TABLE
(
FIELD1 INT,
FIELD2 INT
)
DECLARE @TEST_TABLE2 TABLE
(
FIELD1 INT,
FIELD2 INT
)