--Get matched column names between two tables in the same database

CREATE PROCEDURE GetMatchedColumns_TwoTable

@Table1 Varchar (50), @Table2 Varchar(50)

AS

BEGIN

SET NOCOUNT ON

SELECT * FROM

(SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE

FROM INFORMATION_SCHEMA.COLUMNS

...