How to fire a trigger without changing table data

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+ New
sgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

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 =----

"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+ New
sgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

> 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
> =----

"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+ New
sgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

>>The trigger was firing but not changing data.


Thats what your question says

Madhivanan