34,588
社区成员
发帖
与我相关
我的任务
分享
CREATE PROC titles_for_a_pub
(@pub_name varchar(40)=NULL)
AS
IF @pub_name=NULL
BEGIN
PRINT 'Pass in the pub_name as a parameter'
RETURN
END
BEGIN
SELECT t.title
FROM publishers p, titles t
WHERE p.pub_id=t.pub_id
AND pub_name LIKE @pub_name+'%'
PRINT 'Pass ok'
END
RETURN
BEGIN
PRINT 'Pass in the pub_name as a parameter'
RETURN
END
use pubs
go
CREATE PROC titles_for_a_pub
(@pub_name varchar(40)=NULL)
AS
IF @pub_name is NULL-------------------------
BEGIN
PRINT 'Pass in the pub_name as a parameter'
RETURN
END
else -----------------------------------------
BEGIN
SELECT t.title
FROM publishers p, titles t
WHERE p.pub_id=t.pub_id
AND pub_name LIKE @pub_name+'%'
PRINT 'Pass ok'
END
RETURN
IF ISNULL(@pub_name,'')!=''
这样更严谨