摘要: 我是.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 规则。接下来可以写一段注解,描述 阅读全文
posted @ 2013-04-01 16:42 qiny 阅读(162) 评论(0) 推荐(1) 编辑