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