CSS-HTML.NET
Home > SQL > Using Parameters
HTML
CSS
JavaScript
PHP
VbScript
Web Colors
SQL

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:

Creating a Stored Procedure
GROUP BY
Using Parameters
Modifying a Stored Procedure
Creating a Trigger
Terms and Conditions