Getting text to evaluate

• AndreQ

  SSCommitted

  Points: 1540

  More actions

  April 10, 2003 at 5:31 pm

  #80731

  I'm more familiar with Oracle than SQL Server, so pardon my ignorance. As in many situations, I know what I want to do, but not what its called. Is there a way for T-SQL to evaluate whats in a declared variable?

  For example, something like:

  Declare @MyDatabase varchar(30)

  SELECT @MyDatabase = 'SwitchTo'

  Use @MyDatabase

  Go

  TIA

  AndreQ

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 10, 2003 at 5:41 pm

  #453812

  Use either Exec() or sp_executesql, the latter is usually preferred because SQL will try to cache the query plan. In either case the string executed run's with the callers permissions. We've got a few good articles here on the site about it, search for dynamic sql.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter