SQL Syntax Using Parameters

Using Parameters Examples

CREATE PROCEDURE spSelectStudent (@Course INTEGER, @Grade INTEGER) AS SELECT * FROM Students WHERE Std_Course=@Course AND Std_Grade <= @Grade GO EXEC spSelectStudent 3, 2;

See also SQL syntax for: