数据库存储过程.docx
《数据库存储过程.docx》由会员分享,可在线阅读,更多相关《数据库存储过程.docx(348页珍藏版)》请在冰点文库上搜索。
![数据库存储过程.docx](https://file1.bingdoc.com/fileroot1/2023-5/6/64ad9700-bde6-43fa-9952-860cb3686946/64ad9700-bde6-43fa-9952-860cb36869461.gif)
数据库存储过程
/******************************************************************
*表名:
dt_addtosourcecontrol
*时间:
2011-3-2216:
25:
52
******************************************************************/
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_addtosourcecontrol_Exists]
GO
------------------------------------
--用途:
是否已经存在
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_addtosourcecontrol_Exists
AS
DECLARE@TempIDint
SELECT@TempID=count
(1)FROMdt_addtosourcecontrolWHERE
IF@TempID=0
RETURN0
ELSE
RETURN1
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_addtosourcecontrol_ADD]
GO
------------------------------------
--用途:
增加一条记录
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_addtosourcecontrol_ADD
AS
INSERTINTOdt_addtosourcecontrol(
)VALUES(
)
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_Update]')andOBJECTPROPERTY(id
AS
UPDATEdt_addtosourcecontrolSET
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_addtosourcecontrol_Delete]
GO
------------------------------------
--用途:
删除一条记录
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_addtosourcecontrol_Delete
AS
DELETEdt_addtosourcecontrol
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_addtosourcecontrol_GetModel]
GO
------------------------------------
--用途:
得到实体对象的详细信息
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_addtosourcecontrol_GetModel
AS
SELECT
FROMdt_addtosourcecontrol
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_addtosourcecontrol_GetList]
GO
------------------------------------
--用途:
查询记录信息
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_addtosourcecontrol_GetList
AS
SELECT
FROMdt_addtosourcecontrol
GO
/******************************************************************
*表名:
dt_addtosourcecontrol_u
*时间:
2011-3-2216:
25:
52
******************************************************************/
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_u_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_addtosourcecontrol_u_Exists]
GO
------------------------------------
--用途:
是否已经存在
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_addtosourcecontrol_u_Exists
AS
DECLARE@TempIDint
SELECT@TempID=count
(1)FROMdt_addtosourcecontrol_uWHERE
IF@TempID=0
RETURN0
ELSE
RETURN1
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_u_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_addtosourcecontrol_u_ADD]
GO
------------------------------------
--用途:
增加一条记录
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_addtosourcecontrol_u_ADD
AS
INSERTINTOdt_addtosourcecontrol_u(
)VALUES(
)
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_u_Update]')andOBJECTPROPERTY(id
AS
UPDATEdt_addtosourcecontrol_uSET
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_u_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_addtosourcecontrol_u_Delete]
GO
------------------------------------
--用途:
删除一条记录
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_addtosourcecontrol_u_Delete
AS
DELETEdt_addtosourcecontrol_u
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_u_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_addtosourcecontrol_u_GetModel]
GO
------------------------------------
--用途:
得到实体对象的详细信息
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_addtosourcecontrol_u_GetModel
AS
SELECT
FROMdt_addtosourcecontrol_u
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_u_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_addtosourcecontrol_u_GetList]
GO
------------------------------------
--用途:
查询记录信息
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_addtosourcecontrol_u_GetList
AS
SELECT
FROMdt_addtosourcecontrol_u
GO
/******************************************************************
*表名:
dt_adduserobject
*时间:
2011-3-2216:
25:
52
******************************************************************/
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_adduserobject_Exists]
GO
------------------------------------
--用途:
是否已经存在
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_adduserobject_Exists
AS
DECLARE@TempIDint
SELECT@TempID=count
(1)FROMdt_adduserobjectWHERE
IF@TempID=0
RETURN0
ELSE
RETURN1
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_adduserobject_ADD]
GO
------------------------------------
--用途:
增加一条记录
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_adduserobject_ADD
AS
INSERTINTOdt_adduserobject(
)VALUES(
)
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_Update]')andOBJECTPROPERTY(id
AS
UPDATEdt_adduserobjectSET
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_adduserobject_Delete]
GO
------------------------------------
--用途:
删除一条记录
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_adduserobject_Delete
AS
DELETEdt_adduserobject
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_adduserobject_GetModel]
GO
------------------------------------
--用途:
得到实体对象的详细信息
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_adduserobject_GetModel
AS
SELECT
FROMdt_adduserobject
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_adduserobject_GetList]
GO
------------------------------------
--用途:
查询记录信息
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
52
------------------------------------
CREATEPROCEDUREdt_adduserobject_GetList
AS
SELECT
FROMdt_adduserobject
GO
/******************************************************************
*表名:
dt_adduserobject_vcs
*时间:
2011-3-2216:
25:
53
******************************************************************/
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_vcs_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_adduserobject_vcs_Exists]
GO
------------------------------------
--用途:
是否已经存在
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
53
------------------------------------
CREATEPROCEDUREdt_adduserobject_vcs_Exists
AS
DECLARE@TempIDint
SELECT@TempID=count
(1)FROMdt_adduserobject_vcsWHERE
IF@TempID=0
RETURN0
ELSE
RETURN1
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_vcs_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_adduserobject_vcs_ADD]
GO
------------------------------------
--用途:
增加一条记录
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
53
------------------------------------
CREATEPROCEDUREdt_adduserobject_vcs_ADD
AS
INSERTINTOdt_adduserobject_vcs(
)VALUES(
)
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_vcs_Update]')andOBJECTPROPERTY(id
AS
UPDATEdt_adduserobject_vcsSET
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_vcs_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_adduserobject_vcs_Delete]
GO
------------------------------------
--用途:
删除一条记录
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
53
------------------------------------
CREATEPROCEDUREdt_adduserobject_vcs_Delete
AS
DELETEdt_adduserobject_vcs
WHERE
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_vcs_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[dt_adduserobject_vcs_GetModel]
GO
------------------------------------
--用途:
得到实体对象的详细信息
--项目名称:
--说明:
--时间:
2011-3-2216:
25:
53
----------------------