9 lines
250 B
Plaintext
9 lines
250 B
Plaintext
|
-- SET NOCOUNT ON added to prevent extra result sets from
|
||
|
|
|
||
|
|
SET NOCOUNT ON;
|
||
|
|
SELECT student_id, fname, lname, dob, ACCT_BAL
|
||
|
|
FROM STUDENT
|
||
|
|
WHERE upper(STUDENT_ID) like upper( @studentid )
|
||
|
|
or upper(lname) like upper( @lname )
|
||
|
|
or dob = @dob
|