SQL Server中使用Exists,注意不是“Exist”
if Exists (SELECT newid
FROM invoice
WHERE newid = 13)
begin
select '对'
end
else
begin
select '错'
end
if Exists (SELECT newid
FROM invoice
WHERE newid = 13)
begin
select '对'
end
else
begin
select '错'
end