Monday, March 30, 2015

Parameter passing for dual condition for Stored Procedure


declare @return as Table ( same structure as student )

if @TestType = "dual"
insert into @return ( columns )
select columns from student
else
insert into @return (columns )
select columns from Student
where TestType = @TestType


select * from @return;





karepa


No comments:

Post a Comment