jinlye (1/29/2011)
Subhash Kr Singh (1/28/2011)
UPDATE tablename SET name = 'test'Will it work?
...The straight answer to your question is yes...
PS Don't be put off asking because of earlier responses.
Dear Jinlye, you are wrong, I'm afraid.
In context of this article (and applied trigger) the query will NOT work.
In context of answering general questions about such a basic SQL queries like this - this is wrong thread and/or wrong forum to ask such a question and also to answer it.
That's my humble opinion.