user defined functions in sql server 2000
-
how to build and execute a query in user defined functions? Swaroop.
-
how to build and execute a query in user defined functions? Swaroop.
Swaroop Roy wrote:
how to build and execute a query in user defined functions?
With such a vague question I can only really point you to the documentation: * User Defined Functions[^] * CREATE FUNCTION[^] Does this help?
Scottish Developers events: * .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog
-
how to build and execute a query in user defined functions? Swaroop.
Hi! It is not supported to build and execute a dynamic query in user defined functions. UDFs have to be deterministic -> no
exec( @MyVar )allowed. Rainer. Rainer Stropek Visit my blog at http://www.cubido.at/rainers