Home ›
ASP.NET Forums » Data Access » SQL Server, SQL Server Express, and SqlDataSource Control » Exec SP_ExecuteSQL inside the Userdefined function.

Exec SP_ExecuteSQL inside the Userdefined function.

Last post 07-04-2008 8:25 PM by limno. 1 replies.

Sort Posts:

  • Exec SP_ExecuteSQL inside the Userdefined function.

    07-04-2008, 8:00 PM
    • Loading...
    • balavanchi
    • Joined on 12-13-2007, 11:31 AM
    • Chennai, India
    • Posts 37

    Hi,

    I want to execute EXEC SP_EXECUTESQL  [Query] inside the user defined function. How can I achieve this?

    if not, How run a SP as subquery inside another query.

     ex :

    SELECT a,b,c 

    FROM Table1

    WHERE KEYS IN ( SP )

    can any one suggest me the best answer?

    its so so urgent!!!

    Thanks

    -bala

     

    Please remember to click “Mark as Answer” on the post that helps you

    'work smarter not harder'

  • Re: Exec SP_ExecuteSQL inside the Userdefined function.

    07-04-2008, 8:25 PM
    • Loading...
    • limno
    • Joined on 06-10-2005, 3:50 PM
    • Iowa, USA
    • Posts 3,308
    • Moderator
      TrustedFriends-MVPs

    A useful link: http://www.sommarskog.se/dynamic_sql.html#Cre_tbl

    Limno
Page 1 of 1 (2 items)
RSS Available

Advertise on ASP.NET

About this Site

Microsoft Communities
Page view counter