Cybercrux

Everything is achievable through technology

Dynamic Query

Best Dynamic Query ever

DECLARE	@stmt		nvarchar(255)
DECLARE	@db_name	nvarchar(255)
DECLARE	@schema_name	nvarchar(255)
DECLARE	@Object_name	nvarchar(255)

SET	@stmt	=	'SELECT * FROM [$Database].[$Schema].[$Object]'

SET	@stmt	=	REPLACE(@stmt, '$Database', @db_name)

SET	@stmt	=	REPLACE(@stmt, '$Schema', @schema_name)

SET	@stmt	=	REPLACE(@stmt, '$Object', @Object_name)

EXEC	sp_executeSQL @stmt
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s