how to check data in table without exists condition?

Jun 20 2019 6:08 AM
hi friends 
 
 i need to check data in table without IF EXISTS method
 
if exists (select * from table1 where [columname] in ('data1','data2') /// here data1 is already                                                                                                      in table DATA2 is not in table 
 
begin
    -----select query
end
   else
begin
        ------ insert
end
 
help mee friends 
 
how to find out thees 
 
 
 

Answers (1)