Monday, March 30, 2015

Parameter passing for dual condition for Stored Procedure


select * from student
where ((TestType = '1sem' and @sem='1sem')
or (TestType = '2sem' and @sem='2sem' )
or ((TestType in ('1sem','2sem') and @sem='dual' ))







Hope it Helps!!



No comments:

Post a Comment