Search code examples
sqlsql-serverexecute

call sql from a user defined function

Is it possible with SQL Server 2008 to execute sql from a variabele in a user defined function? Or is using a stored procedure the only solution?

I have an sql statement saved in a variabele

@mySqlStatement = "select * from someTable"

I want to execute the above statement from within a user defined function, is that possible?

Solution

  • Yes it is possible, with restrictions. Please read this.

    Also, be very careful about queries you write that are to be executed in a UDF. Query optimization can be a real problem and so can the number of times queries get executed, depending on how the UDF is called.