• Home
• com.googlecode.etl-unit
• etlunit-sql-server-database
• 1.5.3
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

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