(原创)使用TimeStamp控制并发问题[示例]-创建后台数据库脚本
完整例子https://files.cnblogs.com/Hedonister/TimeStamp.rar
实例所用后台脚本文件,直接运行即可:
(原创)使用TimeStamp控制并发问题[示例]-简要描述
(原创)使用TimeStamp控制并发问题[示例]-.cs脚本
(原创)使用TimeStamp控制并发问题[示例]-页面HTML脚本
实例所用后台脚本文件,直接运行即可:
1
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![](/Images/OutliningIndicators/None.gif)
99![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/None.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
24
![](/Images/OutliningIndicators/None.gif)
25
![](/Images/OutliningIndicators/None.gif)
26
![](/Images/OutliningIndicators/None.gif)
27
![](/Images/OutliningIndicators/None.gif)
28
![](/Images/OutliningIndicators/None.gif)
29
![](/Images/OutliningIndicators/None.gif)
30
![](/Images/OutliningIndicators/None.gif)
31
![](/Images/OutliningIndicators/None.gif)
32
![](/Images/OutliningIndicators/None.gif)
33
![](/Images/OutliningIndicators/None.gif)
34
![](/Images/OutliningIndicators/None.gif)
35
![](/Images/OutliningIndicators/None.gif)
36
![](/Images/OutliningIndicators/None.gif)
37
![](/Images/OutliningIndicators/None.gif)
38
![](/Images/OutliningIndicators/None.gif)
39
![](/Images/OutliningIndicators/None.gif)
40
![](/Images/OutliningIndicators/None.gif)
41
![](/Images/OutliningIndicators/None.gif)
42
![](/Images/OutliningIndicators/None.gif)
43
![](/Images/OutliningIndicators/None.gif)
44
![](/Images/OutliningIndicators/None.gif)
45
![](/Images/OutliningIndicators/None.gif)
46
![](/Images/OutliningIndicators/None.gif)
47
![](/Images/OutliningIndicators/None.gif)
48
![](/Images/OutliningIndicators/None.gif)
49
![](/Images/OutliningIndicators/None.gif)
50
![](/Images/OutliningIndicators/None.gif)
51
![](/Images/OutliningIndicators/None.gif)
52
![](/Images/OutliningIndicators/None.gif)
53
![](/Images/OutliningIndicators/None.gif)
54
![](/Images/OutliningIndicators/None.gif)
55
![](/Images/OutliningIndicators/None.gif)
56
![](/Images/OutliningIndicators/None.gif)
57
![](/Images/OutliningIndicators/None.gif)
58
![](/Images/OutliningIndicators/None.gif)
59
![](/Images/OutliningIndicators/None.gif)
60
![](/Images/OutliningIndicators/None.gif)
61
![](/Images/OutliningIndicators/None.gif)
62
![](/Images/OutliningIndicators/None.gif)
63
![](/Images/OutliningIndicators/None.gif)
64
![](/Images/OutliningIndicators/None.gif)
65
![](/Images/OutliningIndicators/None.gif)
66
![](/Images/OutliningIndicators/None.gif)
67
![](/Images/OutliningIndicators/None.gif)
68
![](/Images/OutliningIndicators/None.gif)
69
![](/Images/OutliningIndicators/None.gif)
70
![](/Images/OutliningIndicators/None.gif)
71
![](/Images/OutliningIndicators/None.gif)
72
![](/Images/OutliningIndicators/None.gif)
73
![](/Images/OutliningIndicators/None.gif)
74
![](/Images/OutliningIndicators/None.gif)
75
![](/Images/OutliningIndicators/None.gif)
76
![](/Images/OutliningIndicators/None.gif)
77
![](/Images/OutliningIndicators/None.gif)
78
![](/Images/OutliningIndicators/None.gif)
79
![](/Images/OutliningIndicators/None.gif)
80
![](/Images/OutliningIndicators/None.gif)
81
![](/Images/OutliningIndicators/None.gif)
82
![](/Images/OutliningIndicators/None.gif)
83
![](/Images/OutliningIndicators/None.gif)
84
![](/Images/OutliningIndicators/None.gif)
85
![](/Images/OutliningIndicators/None.gif)
86
![](/Images/OutliningIndicators/None.gif)
87
![](/Images/OutliningIndicators/None.gif)
88
![](/Images/OutliningIndicators/None.gif)
89
![](/Images/OutliningIndicators/None.gif)
90
![](/Images/OutliningIndicators/None.gif)
91
![](/Images/OutliningIndicators/None.gif)
92
![](/Images/OutliningIndicators/None.gif)
93
![](/Images/OutliningIndicators/None.gif)
94
![](/Images/OutliningIndicators/None.gif)
95
![](/Images/OutliningIndicators/None.gif)
96
![](/Images/OutliningIndicators/None.gif)
97
![](/Images/OutliningIndicators/None.gif)
98
![](/Images/OutliningIndicators/None.gif)
99
![](/Images/OutliningIndicators/None.gif)
(原创)使用TimeStamp控制并发问题[示例]-简要描述
(原创)使用TimeStamp控制并发问题[示例]-.cs脚本
(原创)使用TimeStamp控制并发问题[示例]-页面HTML脚本