Hi all,
I have a table named comments having columns id, name, email, comment, commentedon, approved, and approvedon. In some cases I would like to let the admin of my asp.net web page to approve all the comments at once. Which would be the effective sql code and why?
update comments
set approved='true'
update comments
set approved='true'
where approved='false'
Thank you.