A.Milton Glaser
B.Milton Fridman
C.Thomas Glaser
D.David Glaser
Question 7: Can you tell me what the difference of two SQL statements at
performance of execution?
Statement 1:
if NOT EXISTS (select * from publishers where state = 'NY')
begin
SELECT 'Sales force needs to penetrate New York market'end
else
begin
SELECT 'We have publishers in New York'
end
Statement 2:
if EXISTS (select * from publishers where state = 'NY')
begin
SELECT 'We have publishers in New York'
end
else
begin
SELECT 'Sales force needs to penetrate New York market'
end
A、n1-1
B、n1+n2+n3
C、n2+n3+n4
D、n1