存储过程续2
上一篇 /
下一篇 2008-04-28 14:27:32
/ 个人分类:数据库
IF EXISTS (SELECT name FROM sysobjects51Testing软件测试网i7@c+Df%dN
b
WHERE name = 'au_info' AND type = 'P')
EA|Jn-a4p0 DROP PROCEDURE au_info51Testing软件测试网'c/G%R3A3G7B4_
GO51Testing软件测试网8h0u'KnD!m2@GI
USE pubs51Testing软件测试网[r%Z/~nMq$a
GO51Testing软件测试网2Z~,xd#{/Y.v
CREATE PROCEDURE au_info51Testing软件测试网l%j.@U5H
@lastname varchar(40),51Testing软件测试网@2fF0LS1Y@
@firstname varchar(20)51Testing软件测试网K$nLl4k0_
AS
g#B"C_RE[?0SELECT au_lname, au_fname, title, pub_name