Java Reference
In-Depth Information
You can check the output from this stored procedure by declaring a variable such as
@PFValue and passing it to the stored procedure as an OUTPUT, as shown below.
In this example, the result is stored to a new table, PWCHECK:
DECLARE @PFValue VARCHAR(20)
EXECUTE CHECK_USER_NAME 'Corleone', 'Michael', @PFValue OUTPUT
INSERT INTO PWCHECK
VALUES ('Corleone', 'Michael', @PFValue)
Summary
This chapter provides a brief but fairly comprehensive overview of SQL. You should
now be able to create and populate a database and to use SQL to perform fairly
complex queries.
Specifically, you learn about using SQL when:
Creating and populating databases and tables
Querying a database
Using primary and foreign keys to join tables
Managing database security
Chapter 4
discusses Java Database Connectivity (JDBC), which enables you to use
your knowledge of SQL in a Java application. Much of the rest of the topic explains
how to do this in the context of a variety of practical applications.
