Executing dynamic SQL in a SQLServer 2005 function

by

It “ordinarily” can’t be done as SQL Server treats functions as deterministic, which means that for a given set of inputs, it should always return the same outputs. A stored procedure or dynamic sql can be non-deterministic because it can change external state, such as a table, which is relied on.

Given that in SQL server functions are always deterministic, it would be a bad idea from a future maintenance perspective to attempt to circumvent this as it could cause fairly major confusion for anyone who has to support the code in future.

More Related Contents:

  1. Retrieving last record in each group from database – SQL Server 2005/2008
  2. Base64 encoding in SQL Server 2005 T-SQL
  3. Integer division in sql server
  4. Nested stored procedures containing TRY CATCH ROLLBACK pattern?
  5. How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
  6. get DATEDIFF excluding weekends using sql server
  7. How to upsert (update or insert) in SQL Server 2005
  8. SQL query to find Missing sequence numbers
  9. How to use alias column name in where clause in SQL Server
  10. How do I move files to an archive folder after the files have been processed?
  11. Convert .NET Ticks to SQL Server DateTime
  12. subquery or leftjoin with group by which one is faster?
  13. Calculating timespan with t-sql
  14. Isoweek in SQL Server 2005
  15. SQL Dynamic Pivot – how to order columns
  16. How to delete all rows from all tables in a SQL Server database?
  17. How to update data in one table from corresponding data in another table in SQL Server 2005
  18. Foreign key relationship with composite primary keys in SQL Server 2005
  19. Unique Key Violation in SQL Server – Is it safe to assume Error 2627?
  20. How to recover deleted rows from SQL server table?
  21. SQL Server 2005 – using generated sequences instead of Identity columns?
  22. What good are SQL Server schemas?
  23. What is difference between datetime and timestamp
  24. How do I check if a Sql server string is null or empty
  25. Problem with Renaming a Column in SQL Server
  26. SQL Server 2005 Computed Column Is Persisted
  27. Aggregate SQL Function to grab only the first from each group
  28. SQL Server: How to tell if a database is a system database?
  29. Multiple Select Statements using SQL Server 2005 “WITH” Statement
  30. How do you store a picture in an image column?

Leave a Comment