Forum Replies Created

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

  • RE: Help "Execute stored precedure"

    I've found !

    CREATE PROCEDURE fgirtest(@my_cursor CURSOR VARYING  OUTPUT)

    AS

     SET @my_cursor =  CURSOR STATIC FOR SELECT name FROM chain

     OPEN @my_cursor

    RETURN

    GO

    DECLARE @MyCursor CURSOR

    DECLARE @name VARCHAR(250)

    EXEC fgirtest @MyCursor OUTPUT

    FETCH NEXT FROM...

  • RE: Help "Execute stored precedure"

    I use a cursor, because I want to create a system of rules based on stored procedure which allows to the user to create him self stored procedures with existing...

  • RE: Help "Execute stored precedure"

    of course, i have a field "name" in my table "chain" ....

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