摘要:
我是.net菜鸟。写存储过程之前应该先判断数据库里是否有此存储过程,有就删掉。IF EXISTS (SELECT * FROM dbo.sysobjects where id = object_id(N'ProcedureName') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)DROP PROCEDURE ProcedureNameGOSET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GO上面两段语句只是为了使sqlserver遵从 SQL-92 规则。接下来可以写一段注解,描述 阅读全文