Post reply

how can we see the user defied function's code

  • January 20, 2009 at 12:22 am

    #94455

    how can we see the user defied function's code

    if we have written a stored procedure like "sp1", we can see the code using sp_helptext 'sp1'

    similarly how can we see the code of an written user defined function(UDF) ??

  • January 20, 2009 at 12:37 am

    #929522

    same way..

    sp_helptext 'UDFName'

    -Vikas Bindra

  • January 20, 2009 at 12:37 am

    #929523

    the same way sp_helptext 'fnc'

    Abhijit - http://abhijitmore.wordpress.com

  • January 20, 2009 at 9:27 pm

    #930067

    is it possible to call a user define function in SQL Server from asp.net page (, just like we call a stored procedure from asp.net page) ???

    if so please send me the code to call a function which accepts a number and returns double of it.

  • January 20, 2009 at 10:06 pm

    #930082

    harish_ravi (1/20/2009)

    is it possible to call a user define function in SQL Server from asp.net page (, just like we call a stored procedure from asp.net page) ???

    if so please send me the code to call a function which accepts a number and returns double of it.

    here's a link with a number of examples of how to call a function from ASP.NET:

    http://www.letmegooglethatforyou.com?q=asp.net+call+sql+server+function

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply