I don't get what you really want to do, how about try to send your questions
to: [EMAIL PROTECTED]
There are a lots of real DBAs in that mail list.
>From: Niraj Soni <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
>reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: dynamic cursor in sql
>Date: Tue, 4 Sep 2001 19:50:50 +0530
>
>sorry for off topic
>
>i am deleting more than 1 records from a single table
>now i have an log table
>i want to write log in log table
>
>now i want all records shoud be loggd in log table with one row for each
>
>when i use
>
>select @EmpName from deleted
>
>and user insert into log values ( @EmpName )
>
>if there is more than one record deleted
>in log table i get only one row
>
>i want to use cursor for logging
>
>but if there is delete trigger runs for different conns there is an error
>cursor all ready exist
>
>how can i create dynamic cursor name ??
>
>have any one from list face this type of problem??
>
>plese reply
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
