| Author |
How to fire a trigger without changing table data
|
|
| John Smith 2006-03-27, 8:27 pm |
| 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 droptable.com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.droptable.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
| |
| Tom Moreau 2006-03-27, 8:27 pm |
| Try:
update MyTable
set
Col1 = 'x'
where
1 = 2
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"John Smith" <nobody@nowhere.com> wrote in message
news:1143510748_1010
5@sp6iad.superfeed.net...
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 droptable.com - Unlimited-Unrestricted-Secure Usenet
News==----
http://www.droptable.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
| |
| John Smith 2006-03-28, 3:27 am |
|
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:SL0Wf.1028$m35.96044@news20.bellglobal.com...
> Try:
>
> update MyTable
> set
> Col1 = 'x'
> where
> 1 = 2
Thanks, but it doesn't work.
----== Posted via droptable.com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.droptable.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
| |
| Dan Guzman 2006-03-28, 3:27 am |
| > Thanks, but it doesn't work.
The script Tom posted works for me: Please expand on what you mean by 'it
doesn't work'.
CREATE TABLE MyTable(Col1 int)
GO
CREATE TRIGGER TR_MyTable
ON MyTable FOR INSERT, UPDATE AS
PRINT 'Trigger fired'
GO
UPDATE MyTable
SET Col1 = 'x'
WHERE 1 = 2
GO
DROP TABLE MyTable
GO
--
Hope this helps.
Dan Guzman
SQL Server MVP
"John Smith" <nobody@nowhere.com> wrote in message
news:1143512881_1013
5@sp6iad.superfeed.net...
>
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:SL0Wf.1028$m35.96044@news20.bellglobal.com...
>
> Thanks, but it doesn't work.
>
>
> ----== Posted via droptable.com - Unlimited-Unrestricted-Secure Usenet
> News==----
> http://www.droptable.com The #1 Newsgroup Service in the World! 120,000+
> Newsgroups
> ----= East and West-Coast Server Farms - Total Privacy via Encryption
> =----
| |
| John Smith 2006-03-28, 3:27 am |
|
"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:_s1Wf.9738$tN3.2012@newssvr27.news.prodigy.net...
>
> The script Tom posted works for me: Please expand on what you mean by 'it
> doesn't work'.
Thanks for the help. The problem was due to NULL values in some columns.
The trigger was firing but not changing data.
----== Posted via droptable.com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.droptable.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
| |
| Madhivanan 2006-03-28, 9:29 am |
| >>The trigger was firing but not changing data.
Thats what your question says
Madhivanan
|
|
|
|