Posted by John Smith on 11/03/19 11:43

I have tables that I want to fire either an update or insert trigger on.

I could write a script containing a long list of inserts but I'm looking for
something simpler. Would isql work? Any special conditions to get it to
work?

I've tried tricks like 'update x set col = col' or 'update x set col = col +
'' '

All the alternatives seem to have problems. Any ideas?




----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

• Next in forum: Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties
• Prev in forum: Re: LDAP authentication for Yellowfin on SQLserver
• Thread view: How to fire a trigger without changing table data

[Reply to this message]