CODEWITHSUNDEEP
sqlsql-serverexecute
Jan
Jan

Reputation: 10068

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?

Upvotes: 2

Views: 890

Answers (3)

Randy Minder
Randy Minder

Reputation: 48402

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.

Upvotes: 1

bAN
bAN

Reputation: 13825

For sure yes! You can execute SQL code without using a stored procedure.. (if this is the question..)

Upvotes: 0

escargot agile
escargot agile

Reputation: 22379

Do you mean is it possible to run SQL from an external programming language? Of course it is.

Upvotes: 0

Related Questions