（原创）使用TimeStamp控制并发问题[示例]-创建后台数据库脚本

完整例子https://files.cnblogs.com/Hedonister/TimeStamp.rar

实例所用后台脚本文件,直接运行即可：

Create DataBase T_TimeStamp
2

GO
3

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
4

drop procedure [dbo].[GetData]
5

GO
6

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
7

drop procedure [dbo].[DeleteData]
8

GO
9

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
10

drop procedure [dbo].[InsertData]
11

GO
12

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
13

drop procedure [dbo].[UpdateData]
14

GO
15

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_TimeStamp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
16

drop table [dbo].[T_TimeStamp]
17

GO
18

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_TimeStamp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
19

BEGIN
20

CREATE TABLE [dbo].[T_TimeStamp] (
21

[KID] [int] NOT NULL ,
22

[Name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
23

[TimeStamp] [timestamp] NOT NULL
24

) ON [PRIMARY]
25

END
26

GO
27

ALTER TABLE [dbo].[T_TimeStamp] WITH NOCHECK ADD
28

CONSTRAINT [PK_T_TimeStamp] PRIMARY KEY CLUSTERED
29

(
30

[KID]
31

) ON [PRIMARY]
32

GO
33

SET QUOTED_IDENTIFIER OFF
34

GO
35

SET ANSI_NULLS OFF
36

GO
37

CREATE PROCEDURE GetData
38

@KID int
39

AS
40

SELECT * FROM T_TimeStamp
41

GO
42

SET QUOTED_IDENTIFIER OFF
43

GO
44

SET ANSI_NULLS ON
45

GO
46

SET QUOTED_IDENTIFIER OFF
47

GO
48

SET ANSI_NULLS OFF
49

GO
50

CREATE PROCEDURE DeleteData
51

@KID int
52

AS
53

Delete FROM T_TimeStamp WHERE KID = @KID
54

GO
55

SET QUOTED_IDENTIFIER OFF
56

GO
57

SET ANSI_NULLS ON
58

GO
59

SET QUOTED_IDENTIFIER OFF
60

GO
61

SET ANSI_NULLS OFF
62

GO
63

CREATE PROCEDURE InsertData
64

@Kid int,
65

@Name char(10)
66

AS
67

DECLARE @Count int
68

SELECT @Count = COUNT(*) FROM T_TimeStamp WHERE KID = @Kid
69

IF @Count > 0
70

BEGIN
71

Set @Kid = @Kid + 1
72

END
73

INSERT INTO T_TimeStamp
74

VALUES(@Kid,@Name,null)
75

GO
76

SET QUOTED_IDENTIFIER OFF
77

GO
78

SET ANSI_NULLS ON
79

GO
80

SET QUOTED_IDENTIFIER OFF
81

GO
82

SET ANSI_NULLS OFF
83

GO
84

CREATE PROCEDURE UpdateData
85

@KID int,
86

@Name char(10),
87

@TimeStamp TimeStamp
88

AS
89

Update T_TimeStamp
90

SET Name = @Name
91

WHERE KID = @KID
92

AND TimeStamp = @TimeStamp
93

GO
94

SET QUOTED_IDENTIFIER OFF
95

GO
96

SET ANSI_NULLS ON
97

GO
98

（原创）使用TimeStamp控制并发问题[示例]-简要描述
（原创）使用TimeStamp控制并发问题[示例]-.cs脚本
（原创）使用TimeStamp控制并发问题[示例]-页面HTML脚本

posted @ 2005-06-10 17:17 冰戈阅读(1614) 评论(1) 编辑收藏举报

刷新页面返回顶部

（原创）使用TimeStamp控制并发问题[示例]-创建后台数据库脚本

公告