（原创）使用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![]()
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脚本
浙公网安备 33010602011771号