Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-sqlserver > #301

Re: SSE 2008: Table Parameters

From Gene Wirchenko <genew@ocis.net>
Newsgroups comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject Re: SSE 2008: Table Parameters
Date 2011-05-06 15:33 -0700
Organization A noiseless patient Spider
Message-ID <p4t8s6tl8dk779p73l01r81iv6da7de9p5@4ax.com> (permalink)
References <unr8s65naj0l34l6vqr6s28esiur3n8ffv@4ax.com>

Cross-posted to 2 groups.

Show all headers | View raw


On Fri, 06 May 2011 15:00:39 -0700, Gene Wirchenko <genew@ocis.net>
wrote:

>Dear SQLers:
>
>     I have been digging into cursors.  It appears that one can not
                                      ^ and the like
>modify a cursor variable passed as a parameter.  Being able to do so
          ^^^^^^
>would be very useful.  What do you do when you need to modify a cursor
 ^^^^^^
>parameter?  Or what is the workaround?

     Whoops!  Read as "table".

     What do you do when you want to treat a cursor as a table?

     I want to build a cursor of data manipulating it with SQL
commands as I would a table and then update another table using the
cursor as a cursor.

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

SSE 2008: Table Parameters Gene Wirchenko <genew@ocis.net> - 2011-05-06 15:00 -0700
  Re: SSE 2008: Table Parameters Gene Wirchenko <genew@ocis.net> - 2011-05-06 15:33 -0700
    Re: SSE 2008: Table Parameters Erland Sommarskog <esquel@sommarskog.se> - 2011-05-07 11:51 +0200

csiph-web