数据库存储过程Word格式文档下载.docx

数据库存储过程Word格式文档下载.docx

《数据库存储过程Word格式文档下载.docx》由会员分享，可在线阅读，更多相关《数据库存储过程Word格式文档下载.docx（348页珍藏版）》请在冰点文库上搜索。

IsProcedure'

）=1）

dropprocedure[dbo].[dt_addtosourcecontrol_Exists]

GO

------------------------------------

--用途：

是否已经存在

--项目名称：

--说明：

--时间：

CREATEPROCEDUREdt_addtosourcecontrol_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count

（1）FROMdt_addtosourcecontrolWHERE

IF@TempID=0

RETURN0

ELSE

RETURN1

[dbo].[dt_addtosourcecontrol_ADD]'

dropprocedure[dbo].[dt_addtosourcecontrol_ADD]

增加一条记录

CREATEPROCEDUREdt_addtosourcecontrol_ADD

AS

INSERTINTOdt_addtosourcecontrol（

）VALUES（

）

[dbo].[dt_addtosourcecontrol_Update]'

）andOBJECTPROPERTY（id

UPDATEdt_addtosourcecontrolSET

WHERE

[dbo].[dt_addtosourcecontrol_Delete]'

dropprocedure[dbo].[dt_addtosourcecontrol_Delete]

删除一条记录

CREATEPROCEDUREdt_addtosourcecontrol_Delete

DELETEdt_addtosourcecontrol

[dbo].[dt_addtosourcecontrol_GetModel]'

dropprocedure[dbo].[dt_addtosourcecontrol_GetModel]

得到实体对象的详细信息

CREATEPROCEDUREdt_addtosourcecontrol_GetModel

SELECT

FROMdt_addtosourcecontrol

[dbo].[dt_addtosourcecontrol_GetList]'

dropprocedure[dbo].[dt_addtosourcecontrol_GetList]

查询记录信息

CREATEPROCEDUREdt_addtosourcecontrol_GetList

dt_addtosourcecontrol_u

[dbo].[dt_addtosourcecontrol_u_Exists]'

dropprocedure[dbo].[dt_addtosourcecontrol_u_Exists]

CREATEPROCEDUREdt_addtosourcecontrol_u_Exists

SELECT@TempID=count

（1）FROMdt_addtosourcecontrol_uWHERE

[dbo].[dt_addtosourcecontrol_u_ADD]'

dropprocedure[dbo].[dt_addtosourcecontrol_u_ADD]

CREATEPROCEDUREdt_addtosourcecontrol_u_ADD

INSERTINTOdt_addtosourcecontrol_u（

[dbo].[dt_addtosourcecontrol_u_Update]'

UPDATEdt_addtosourcecontrol_uSET

[dbo].[dt_addtosourcecontrol_u_Delete]'

dropprocedure[dbo].[dt_addtosourcecontrol_u_Delete]

CREATEPROCEDUREdt_addtosourcecontrol_u_Delete

DELETEdt_addtosourcecontrol_u

[dbo].[dt_addtosourcecontrol_u_GetModel]'

dropprocedure[dbo].[dt_addtosourcecontrol_u_GetModel]

CREATEPROCEDUREdt_addtosourcecontrol_u_GetModel

FROMdt_addtosourcecontrol_u

[dbo].[dt_addtosourcecontrol_u_GetList]'

dropprocedure[dbo].[dt_addtosourcecontrol_u_GetList]

CREATEPROCEDUREdt_addtosourcecontrol_u_GetList

dt_adduserobject

[dbo].[dt_adduserobject_Exists]'

dropprocedure[dbo].[dt_adduserobject_Exists]

CREATEPROCEDUREdt_adduserobject_Exists

SELECT@TempID=count

（1）FROMdt_adduserobjectWHERE

[dbo].[dt_adduserobject_ADD]'

dropprocedure[dbo].[dt_adduserobject_ADD]

CREATEPROCEDUREdt_adduserobject_ADD

INSERTINTOdt_adduserobject（

[dbo].[dt_adduserobject_Update]'

UPDATEdt_adduserobjectSET

[dbo].[dt_adduserobject_Delete]'

dropprocedure[dbo].[dt_adduserobject_Delete]

CREATEPROCEDUREdt_adduserobject_Delete

DELETEdt_adduserobject

[dbo].[dt_adduserobject_GetModel]'

dropprocedure[dbo].[dt_adduserobject_GetModel]

CREATEPROCEDUREdt_adduserobject_GetModel

FROMdt_adduserobject

[dbo].[dt_adduserobject_GetList]'

dropprocedure[dbo].[dt_adduserobject_GetList]

CREATEPROCEDUREdt_adduserobject_GetList

dt_adduserobject_vcs

53

[dbo].[dt_adduserobject_vcs_Exists]'

dropprocedure[dbo].[dt_adduserobject_vcs_Exists]

CREATEPROCEDUREdt_adduserobject_vcs_Exists

SELECT@TempID=count

（1）FROMdt_adduserobject_vcsWHERE

[dbo].[dt_adduserobject_vcs_ADD]'

dropprocedure[dbo].[dt_adduserobject_vcs_ADD]

CREATEPROCEDUREdt_adduserobject_vcs_ADD

INSERTINTOdt_adduserobject_vcs（

[dbo].[dt_adduserobject_vcs_Update]'

UPDATEdt_adduserobject_vcsSET

[dbo].[dt_adduserobject_vcs_Delete]'

dropprocedure[dbo].[dt_adduserobject_vcs_Delete]

CREATEPROCEDUREdt_adduserobject_vcs_Delete

DELETEdt_adduserobject_vcs

[dbo].[dt_adduserobject_vcs_GetModel]'

dropprocedure[dbo].[dt_adduserobject_vcs_GetModel]

----------------------