26) 在SQL Server 2000中,与以下T-SQL等效的是()。(选择一项)
update titles set price=price*1.05 where pub_id in(select pub_id from publishers)
a) update titles set price=price*1.05 where exists (select pub_id from publishers)
b) update titles set price=price*1.05 from titles where pub_id publishers .pub_id
c) update titles set price=price*1.05 where titles.pub_id=publishers.pub_id
d) update titles set price=price*1.05 from titles inner join publishers on titles.pub_id=publishers.pub_id
哪个对呢?
update titles set price=price*1.05 where pub_id in(select pub_id from publishers)
a) update titles set price=price*1.05 where exists (select pub_id from publishers)
b) update titles set price=price*1.05 from titles where pub_id publishers .pub_id
c) update titles set price=price*1.05 where titles.pub_id=publishers.pub_id
d) update titles set price=price*1.05 from titles inner join publishers on titles.pub_id=publishers.pub_id
哪个对呢?
选项A条件太松,可能吴更新很多记录
选项B则本身有点错误
选项C很明显不对