Home Forums SQL Server 2005 T-SQL (SS2K5) Can a CURSOR be populated by firing a stored procedure? RE: Can a CURSOR be populated by firing a stored procedure?

  • Actually you can, if you really want or need to!

    You should use cursor datatype in output parameter of your procedure. Here you will find a sample:

    http://msdn.microsoft.com/en-GB/library/ms175498(v=sql.105).aspx

    Should, also mention that this technique is not used very often...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]