Of the two answers provided DML is the choice, however:

http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/03/08/why-select-queries-are-not-dml.aspx

there are other opinions.