摘要: 写以下几个存储过程:RegionUpdate: 多个参数CREATE PROCEDURE RegionUpdate(@RegionID INTEGER, @RegionDescription NCHAR(50))ASSET NOCOUNT OFFUPDATE RegionSET RegionDescription = @RegionDescriptionWHERE RegionID = @RegionIDGORegionDelete 一个参数CREATE PROCEDURE RegionUpdate(@RegionID INTEGER)ASSET NOCOUNT OFFDELETE FROM 阅读全文
posted @ 2012-07-15 18:24 ``炯`` 阅读(218) 评论(0) 推荐(0) 编辑
摘要: 1.判断要创建的表是否已经存在if exists (select * from sysobjects where id=OBJECT_ID(N'[dbo].[GetNdemoApplyDetail]')and OBJECTPROPERTY(id,N'IsUserTable')=1)2.判断要创建的存储过程是否已经存在if exists (select * from sysobjects where id=OBJECT_ID(N'[dbo].[存储过程名称]')and OBJECTPROPERTY(id,N'IsProcedure' 阅读全文
posted @ 2012-07-15 18:08 ``炯`` 阅读(1640) 评论(0) 推荐(0) 编辑