NULL Parameter Check in SQL Server

Lakhangarg
Posted by Lakhangarg under Sql Server category on | Views : 3177
Suppose we have variable @str_Student_Type if null then get all records else add filter.

(@str_Student_Type is NULL OR int_Type = @str_Student_Type)


Thanks & Regards
Lakhan Pal Garg

Comments or Responses

Login to post response