Select using value from parameter : Parameter « Procedure Function « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Procedure Function
3. Parameter

4>
5> CREATE TABLE Authors(
6>   au_id    varchar(11) NOT NULL,
7>   au_lname varchar(40) NOT NULL,
8>   au_fname varchar(20) NOT NULL,
9>   phone    char(12)    NOT NULL,
10>   address  varchar(40) NULL,
11>   city     varchar(20) NULL,
12>   state    char(2)     NULL,
13>   zip      char(5)     NULL,
14>   contract bit         NOT NULL
15> );
16> GO
1>
2> CREATE PROC AuthorsInState
3>   @state char(2)
4> AS
5> SELECT
6>   *
7> FROM
8>   authors
9> WHERE
10>   state = @state
11> GO
1>
2> drop proc AuthorsInState;
3> GO
1>
2> drop table Authors;
3> GO
1>
2>
3>
4>