How to check whether record exists in table or not?

 Posted by Rajesh_Kumar on 1/20/2014 | Category: Sql Server Interview questions | Views: 2155 | Points: 40
Answer:

Use count function to check whether record is present in a table or not.

For Example:-
Select count(code_id) from code_details where code_value = 'apt0';


It will return number of record count related to code_value 'apt0'


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response