Database

Msg 205, Level 16, State 1, Line 1<br />
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

CREATE TABLE #first
(
	Id INT NOT NULL,
	Name VARCHAR(10) NOT NULL
);

CREATE TABLE #second
(
	Id INT NOT NULL,
	Name VARCHAR(10) NOT NULL
);

INSERT INTO #first (Id, Name) VALUES (1, 'One');
INSERT INTO #first (Id, Name) VALUES (2, 'Two');
INSERT INTO #first (Id, Name) VALUES (3, 'Three');
INSERT INTO #first (Id, Name) VALUES (9, 'Nine');

INSERT INTO #second (Id, Name) VALUES (2, 'Two');
INSERT INTO #second (Id, Name) VALUES (3, 'Three');
INSERT INTO #second (Id, Name) VALUES (5, 'Five');
INSERT INTO #second (Id, Name) VALUES (7, 'Seven');

SELECT f.Id AS fid, 
	f.Name AS fname,
	s.Id AS [sid],
	s.Name AS sname
FROM #first f
	FULL OUTER JOIN #second s
		ON s.Id = f.Id
WHERE s.Id IS NULL OR f.Id IS NULL

DROP TABLE #first;
DROP TABLE #second;

select *
into database.owner.tablename
from table