IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID('SP_DC003'))
DROP PROCEDURE SP_DC003
这样写好吗?还是联机丛书里的好?
IF EXISTS (SELECT NAME SYSOBJECTS WHERE NAME='SP_DC003'AND TYPE='P')
DROP PROCEDURE SP_DC003
DROP PROCEDURE SP_DC003
这样写好吗?还是联机丛书里的好?
IF EXISTS (SELECT NAME SYSOBJECTS WHERE NAME='SP_DC003'AND TYPE='P')
DROP PROCEDURE SP_DC003
SELECT NAME FROM SYSOBJECTS WHERE NAME='authors'AND TYPE='u'个人觉得第二种会好些吧,select name 应该别select * 快,而且第二种没用OBJECT_ID这样的系统函数