Execute Stored Procedure from a Function

by

EDIT: I haven’t tried this, so I can’t vouch for it! And you already know you shouldn’t be doing this, so please don’t do it. BUT…

Try looking here: http://sqlblog.com/blogs/denis_gobo/archive/2008/05/08/6703.aspx

The key bit is this bit which I have attempted to tweak for your purposes:

DECLARE @SQL varchar(500)

SELECT @SQL = 'osql -S' +@@servername +' -E -q "exec dbName..sprocName "'

EXEC master..xp_cmdshell @SQL

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. How to SELECT FROM stored procedure
  3. Pass table as parameter into sql server UDF
  4. SQL : in clause in stored procedure:how to pass values
  5. Eliminate and reduce overlapping date ranges
  6. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  7. How can I do an UPDATE statement with JOIN in SQL Server?
  8. The multi-part identifier could not be bound
  9. Fastest way to update 120 Million records
  10. Can a Check constraint relate to another table?
  11. Is it possible to select sql server data using column ordinal position
  12. How to find current transaction level?
  13. How to insert multiple records and get the identity value?
  14. How to Replace Multiple Characters in SQL?
  15. SQL: Select dynamic column name based on variable
  16. EXISTS vs JOIN and use of EXISTS clause
  17. Why is a UDF so much slower than a subquery?
  18. SQL comma-separated row with Group By clause
  19. How to copy a huge table data into another table in SQL Server
  20. How to split string using delimiter char using T-SQL?
  21. Should I use SQL_Variant data type?
  22. SQL server select distinct rows using most recent value only
  23. Script to save varbinary data to disk
  24. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  25. What is the internal representation of datetime in sql server?
  26. Cumulative Total in MS Sql server [duplicate]
  27. SQL query to group by day
  28. Export table data from one SQL Server to another
  29. Dynamic order direction
  30. SQL, How to Concatenate results?

Leave a Comment