Post reply

insert into table

  • December 2, 2003 at 5:27 am

    #81678

    Hi,

    is it possible to write insert into table statment in the body of a function?

    How to insert values into a table?

    Thanks, Jelena

  • December 2, 2003 at 5:31 am

    #484241

    It's not possible to insert into a table in the body of a function unless it's a table variable local to the function. You would need to use a stored procedure to do that.

    Cheers,

    mia

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.


    Cheers,
    mia

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.

  • December 2, 2003 at 5:35 am

    #484243

    I tried that but I can't execute stored procedure inside a function?

    How to solve that?

    THanks, Jelena

  • December 2, 2003 at 5:37 am

    #484244

    What are you trying to do?

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 2, 2003 at 5:38 am

    #484246

    Can't you replace the function entirely with a stored procedure? What is it that you are trying to do?

    Cheers,

    mia

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.


    Cheers,
    mia

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.

  • December 2, 2003 at 5:46 am

    #484253

    It's not problem to write stored procedure but later I need rto select some values from....(function)

  • December 2, 2003 at 5:47 am

    #484254

    ???

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 2, 2003 at 5:53 am

    #484255

    Not sure what you mean. What's the purpose of the stored procedure? To insert values or retrieve them?? Can you post some code to demonstrate more clearly what you're trying to do?

    Cheers,

    mia

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.


    Cheers,
    mia

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.

Viewing 8 posts - 1 through 7 (of 7 total)

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