sql use statement with variable

by

The problem with the former is that what you’re doing is USE 'myDB' rather than USE myDB.
you’re passing a string; but USE is looking for an explicit reference.

The latter example works for me.

declare @sql varchar(20)
select @sql="USE myDb"
EXEC sp_sqlexec @Sql

-- also works
select @sql="USE [myDb]"
EXEC sp_sqlexec @Sql

More Related Contents:

  1. Check if table exists in SQL Server
  2. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  3. Simulation of CONNECT BY PRIOR of Oracle in SQL Server
  4. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  5. Do I really need to use “SET XACT_ABORT ON”?
  6. Creating audit triggers in SQL Server
  7. Regular Expressions in SQL Server servers?
  8. T-SQL Dynamic SQL and Temp Tables
  9. How do you specify a different port number in SQL Management Studio?
  10. How to determine total number of open/active connections in ms sql server 2005
  11. Dynamic SQL results into temp table in SQL Stored procedure
  12. Find non-ASCII characters in varchar columns using SQL Server
  13. Dynamic SQL to generate column names?
  14. Diagnosing Deadlocks in SQL Server 2005
  15. Disadvantages of MARS (Multiple Active Result Sets)?
  16. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  17. Aggregate bitwise-OR in a subquery
  18. Check if a temporary table exists and delete if it exists before creating a temporary table
  19. Drop primary key using script in SQL Server database [duplicate]
  20. Decimal values in SQL for dividing results
  21. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  22. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  23. How to store directory / hierarchy / tree structure in the database?
  24. Date range overlapping check constraint
  25. INFORMATION_SCHEMA vs sysobjects
  26. Bulk insert fixed width fields
  27. Does query plan optimizer works well with joined/filtered table-valued functions?
  28. What are row, page and table locks? And when they are acquired?
  29. Cross Domain SQL Server Logins Using Windows Authentication
  30. How to cleanse (prevent SQL injection) dynamic SQL in SQL Server?

Leave a Comment