9-01.sql

sql2000工程实践一书第9张源代码

USE pubs
IF EXISTS (SELECT name FROM sysobjects 
         WHERE name = 'pub_info2' AND type = 'P')
   DROP PROCEDURE pub_info2
GO
CREATE PROC pub_info2 @pubname varchar(40) = 'Algodata Infosystems'
AS 
SELECT au_lname, au_fname, pub_name
FROM authors a INNER JOIN titleauthor ta ON a.au_id = ta.au_id
   JOIN titles t ON ta.title_id = t.title_id
   JOIN publishers p ON t.pub_id = p.pub_id
WHERE @pubname = p.pub_name
GO