Using a Variable in OPENROWSET Query

by

As suggested by Scott , you cannot use expressions in OPENROWSET.Try creating a dynamic sql to pass the parameters

Declare @ID int
Declare @sql nvarchar(max)
Set @ID=1
Set @sql="SELECT * 
FROM OPENROWSET(
               "'SQLNCLI'',
               ''DRIVER={SQL Server};'',
               ''EXEC dbo.usp_SO @ID =' + convert(varchar(10),@ID) + ''')'

-- Print @sql
 Exec(@sql)

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. sql server 2008 management studio not checking the syntax of my query
  3. Split function equivalent in T-SQL?
  4. Is the NOLOCK (Sql Server hint) bad practice?
  5. How to create a table from select query result in SQL Server 2008 [duplicate]
  6. Querying data by joining two tables in two database on different servers
  7. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  8. Where value in column containing comma delimited values
  9. How to find all connected subgraphs of an undirected graph
  10. Parse comma-separated string to make IN List of strings in the Where clause
  11. How to use table variable in a dynamic sql statement?
  12. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  13. OPTION (RECOMPILE) is Always Faster; Why?
  14. Create Trigger to log SQL that affected table?
  15. Transfer data from one database to another database
  16. How to find third or nᵗʰ maximum salary from salary table?
  17. SQL “between” not inclusive
  18. Can I set ignore_dup_key on for a primary key?
  19. Selecting first row per group
  20. Using PIVOT in SQL Server 2008
  21. How do I prevent a database trigger from recursing?
  22. sql group by only rows which are in sequence
  23. Function in SQL Server 2008 similar to GREATEST in mysql?
  24. Converting Select results into Insert script – SQL Server
  25. How to retrieve field names from temporary table (SQL Server 2008)
  26. When using GETDATE() in many places, is it better to use a variable?
  27. Executing SQL Server Agent Job from a stored procedure and returning job result
  28. Cumulative Total in MS Sql server [duplicate]
  29. How do I find the data directory for a SQL Server instance?
  30. Safest way to get last record ID from a table

Leave a Comment