（原创）使用TimeStamp控制并发问题[示例]-创建后台数据库脚本
完整例子https://files.cnblogs.com/Hedonister/TimeStamp.rar
实例所用后台脚本文件,直接运行即可：
（原创）使用TimeStamp控制并发问题[示例]-简要描述
（原创）使用TimeStamp控制并发问题[示例]-.cs脚本
（原创）使用TimeStamp控制并发问题[示例]-页面HTML脚本
实例所用后台脚本文件,直接运行即可：
1
Create DataBase T_TimeStamp
2GO
3if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
4drop procedure [dbo].[GetData]
5GO
6if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DeleteData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
7drop procedure [dbo].[DeleteData]
8GO
9if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InsertData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
10drop procedure [dbo].[InsertData]
11GO
12if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
13drop procedure [dbo].[UpdateData]
14GO
15if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_TimeStamp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
16drop table [dbo].[T_TimeStamp]
17GO
18if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_TimeStamp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
19 BEGIN
20CREATE 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]
25END
26GO
27ALTER TABLE [dbo].[T_TimeStamp] WITH NOCHECK ADD
28 CONSTRAINT [PK_T_TimeStamp] PRIMARY KEY CLUSTERED
29 (
30 [KID]
31 ) ON [PRIMARY]
32GO
33SET QUOTED_IDENTIFIER OFF
34GO
35SET ANSI_NULLS OFF
36GO
37CREATE PROCEDURE GetData
38@KID int
39 AS
40SELECT * FROM T_TimeStamp
41GO
42SET QUOTED_IDENTIFIER OFF
43GO
44SET ANSI_NULLS ON
45GO
46SET QUOTED_IDENTIFIER OFF
47GO
48SET ANSI_NULLS OFF
49GO
50CREATE PROCEDURE DeleteData
51@KID int
52 AS
53Delete FROM T_TimeStamp WHERE KID = @KID
54GO
55SET QUOTED_IDENTIFIER OFF
56GO
57SET ANSI_NULLS ON
58GO
59SET QUOTED_IDENTIFIER OFF
60GO
61SET ANSI_NULLS OFF
62GO
63CREATE PROCEDURE InsertData
64 @Kid int,
65 @Name char(10)
66 AS
67DECLARE @Count int
68SELECT @Count = COUNT(*) FROM T_TimeStamp WHERE KID = @Kid
69IF @Count > 0
70BEGIN
71Set @Kid = @Kid + 1
72END
73INSERT INTO T_TimeStamp
74VALUES(@Kid,@Name,null)
75GO
76SET QUOTED_IDENTIFIER OFF
77GO
78SET ANSI_NULLS ON
79GO
80SET QUOTED_IDENTIFIER OFF
81GO
82SET ANSI_NULLS OFF
83GO
84CREATE PROCEDURE UpdateData
85 @KID int,
86 @Name char(10),
87 @TimeStamp TimeStamp
88AS
89Update T_TimeStamp
90SET Name = @Name
91WHERE KID = @KID
92AND TimeStamp = @TimeStamp
93GO
94SET QUOTED_IDENTIFIER OFF
95GO
96SET ANSI_NULLS ON
97GO
98
99
Create DataBase T_TimeStamp2
GO3
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
GO6
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
GO9
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
GO12
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
GO15
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
GO18
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_TimeStamp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)19
BEGIN20
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
END26
GO27
ALTER TABLE [dbo].[T_TimeStamp] WITH NOCHECK ADD 28
CONSTRAINT [PK_T_TimeStamp] PRIMARY KEY CLUSTERED 29
(30
[KID]31
) ON [PRIMARY] 32
GO33
SET QUOTED_IDENTIFIER OFF 34
GO35
SET ANSI_NULLS OFF 36
GO37
CREATE PROCEDURE GetData38
@KID int39
AS40
SELECT * FROM T_TimeStamp41
GO42
SET QUOTED_IDENTIFIER OFF 43
GO44
SET ANSI_NULLS ON 45
GO46
SET QUOTED_IDENTIFIER OFF 47
GO48
SET ANSI_NULLS OFF 49
GO50
CREATE PROCEDURE DeleteData51
@KID int52
AS53
Delete FROM T_TimeStamp WHERE KID = @KID54
GO55
SET QUOTED_IDENTIFIER OFF 56
GO57
SET ANSI_NULLS ON 58
GO59
SET QUOTED_IDENTIFIER OFF 60
GO61
SET ANSI_NULLS OFF 62
GO63
CREATE PROCEDURE InsertData64
@Kid int,65
@Name char(10)66
AS67
DECLARE @Count int68
SELECT @Count = COUNT(*) FROM T_TimeStamp WHERE KID = @Kid69
IF @Count > 0 70
BEGIN 71
Set @Kid = @Kid + 172
END 73
INSERT INTO T_TimeStamp74
VALUES(@Kid,@Name,null)75
GO76
SET QUOTED_IDENTIFIER OFF 77
GO78
SET ANSI_NULLS ON 79
GO80
SET QUOTED_IDENTIFIER OFF 81
GO82
SET ANSI_NULLS OFF 83
GO84
CREATE PROCEDURE UpdateData 85
@KID int,86
@Name char(10),87
@TimeStamp TimeStamp88
AS89
Update T_TimeStamp90
SET Name = @Name91
WHERE KID = @KID92
AND TimeStamp = @TimeStamp93
GO94
SET QUOTED_IDENTIFIER OFF 95
GO96
SET ANSI_NULLS ON 97
GO98
99
（原创）使用TimeStamp控制并发问题[示例]-简要描述
（原创）使用TimeStamp控制并发问题[示例]-.cs脚本
（原创）使用TimeStamp控制并发问题[示例]-页面HTML脚本
