sql²åÈëÎÊÌâÇó½ÌÎÊÌâ

A±íµÄ T1×Ö¶ÎÊÇÖ÷¼ü ÀàÐÍÊÇÕûÐÍ

ÿ´Î²åÈëʱºò¶¼È¡ max(T1),È»ºó²åÈëmax(T1)+1£¬ T1²»ÊÇ×Ô¶¯µÝÔöµÄ


Çë½ÌÓÐʲôºÃµÄ·½·¨¿ÉÒÔ·ÀÖ¹N¸ö¿Í»§¶Ëͬʱ²åÈëµÄʱºò²»»á²åÈëÖظ´Öµ£¬ÏÖÔÚÀÏÌáʾ²»ÄܲåÈëÖظ´È»ºó¾Í²åÈëʧ°Ü
max(T1)+1»¹ÐèÒªÏòÆäËû±í²åÈëµÄ ËùÒÔ²»ÄÜÉèÖÃ×Ô¶¯µÝÔö£¬¸÷λÓÐʲôºÃ·½·¨¿ÉÒÔ±ÜÃâ²åÈëÖظ´Âð£¿

---

²Î¿¼£ºhttp://blog.csdn.net/htl258/archive/2009/03/26/4027976.aspx

---

Ìí¼ÓΨһÐÔÔ¼Êø»òÔÚÊÂÎï´¦Àí¡£

---

SQL code:
CREATE FUNCTION f_NextT1()
RETURNS INT
AS
BEGIN
RETURN(SELECT MAX(T1)+1 from tb WITH(XLOCK,PAGLOCK))
END
GO
CREATE TABLE tb(
T1 int PRIMARY KEY DEFAULT dbo.f_NextT1(),
[name] varchar(10))

---

ÒýÓÃ

SQL code
CREATE FUNCTION f_NextT1()
RETURNS INT
AS
BEGIN
RETURN(SELECT MAX(T1)+1 from tb WITH(XLOCK,PAGLOCK))
END
GO
CREATE TABLE tb(
T1 int PRIMARY KEY DEFAULT dbo.f_NextT1(),
[name] va¡­¡­

¶¥...

---

ÒýÓÃ

SQL code
CREATE FUNCTION f_NextT1()
RETURNS INT
AS
BEGIN
RETURN(SELECT MAX(T1)+1 from tb WITH(XLOCK,PAGLOCK))
END
GO
CREATE TABLE tb(
T1 int PRIMARY KEY DEFAULT dbo.f_NextT1(),
[name] va¡­¡­

C# code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://