A possible solution would be to implement a stored function, like:
CREATE FUNCTION v_student (@pintSno INT)
RETURNS TABLE
AS
RETURN
SELECT * FROM Student WHERE stu_id=@pintSno ;
This allows you to use it as a normal view, with:
SELECT * FROM v_student (3)
CREATE FUNCTION v_student (@pintSno INT)
RETURNS TABLE
AS
RETURN
SELECT * FROM Student WHERE stu_id=@pintSno ;
This allows you to use it as a normal view, with:
SELECT * FROM v_student (3)
No comments:
Post a Comment