0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those involved in the field of teaching Computer Science

create table #CheckTest(
    name varchar(50)
)


if (select case when (select count(*) from #CheckTest) = 0 then 1 else 0 end
    +
    (select count(*) from #CheckTest where name = 'test') ) > 0
begin
   select 'fail'
end
else
begin
  select 'success'
end

view current version

edited feb 7 12

created feb 7 12 anonymous