RSS

Monthly Archives: November 2012

Switching databases dynamically

DECLARE @vsql NVARCHAR(MAX)

DECLARE @sp_executesql NVARCHAR(50) = QUOTENAME(‘Database Name here’) + ‘.sys.sp_executesql’;

SET @vsql = ‘—enter code here —‘

EXEC @sp_executesql @vsql;

 

 
Leave a comment

Posted by on November 15, 2012 in Tips and Tricks