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

Re: SSE 2008: Table Trigger

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: SSE 2008: Table Trigger
Date	2011-04-13 08:27 +0000
Organization	Erland Sommarskog
Message-ID	<Xns9EC66A5ED42FYazorman@127.0.0.1> (permalink)
References	<o5e9q6lip6cg4qf1rrlf1i9omjavqf56tc@4ax.com> <Xns9EC61A32CD3DYazorman@127.0.0.1> <llq9q6p4jp6qudtr98uvt9vgm7f1l5nrk3@4ax.com>

Cross-posted to 2 groups.

Show all headers | View raw

Gene Wirchenko (genew@ocis.net) writes:
>      I was thinking it would then be temporary.  Does that not work
> with cursors?
 
Nope. Actually, since you asked, I had to test:

create procedure testis as
declare  #cur cursor for select name from sys.columns
open #cur
fetch #cur
go
exec testis
exec testis
go
deallocate #cur
drop procedure testis



-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

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

Thread

SSE 2008: Table Trigger Gene Wirchenko <genew@ocis.net> - 2011-04-12 13:46 -0700
  Re: SSE 2008: Table Trigger Erland Sommarskog <esquel@sommarskog.se> - 2011-04-13 00:09 +0200
    Re: SSE 2008: Table Trigger Gene Wirchenko <genew@ocis.net> - 2011-04-12 17:27 -0700
      Re: SSE 2008: Table Trigger Erland Sommarskog <esquel@sommarskog.se> - 2011-04-13 08:27 +0000

csiph-web