e.etl-unit.etlunit-sql-server-database.1.6.6.source-code.export_sql_columns.vm Maven / Gradle / Ivy

Go to download

USE ${databaseName}
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'${procedureName}') AND type in (N'P', N'PC'))
	DROP PROCEDURE ${procedureName}
GO

CREATE PROCEDURE ${procedureName} AS
BEGIN
	SET NOCOUNT ON

	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'${tempTableName}') AND type = N'U')
		DROP TABLE ${tempTableName}
	GO

	SELECT * INTO ${tempTableName} FROM
	(
		$sql
	) A

	SELECT c.name FROM SYS.tables t JOIN SYS.COLUMNS c ON t.object_id = c.object_id WHERE t.name = '${tempTableName}'

	DROP TABLE ${tempTableName}
END

GO