22,301
社区成员




IF OBJECT_ID('TA') IS NOT NULL
DROP TABLE TA
GO
CREATE TABLE TA(ID INT PRIMARY KEY, COL1 DATETIME)
GO
INSERT INTO TA VALUES(1, GETDATE())
GO
IF OBJECT_ID('TB') IS NOT NULL
DROP TABLE TB
GO
IF OBJECT_ID('F_NEXTBH') IS NOT NULL
DROP FUNCTION F_NEXTBH
GO
CREATE FUNCTION F_NEXTBH()
RETURNS CHAR(8)
AS BEGIN
RETURN (
SELECT 'BH' + RIGHT(1000001 + ISNULL(RIGHT(MAX(BH), 6), 0), 6)
FROM TB WITH(XLOCK, PAGLOCK))
END
GO
CREATE TABLE TB(BH CHAR(8) PRIMARY KEY DEFAULT DBO.F_NEXTBH(),
COL1 INT)
GO
BEGIN TRAN
INSERT INTO TB(COL1) VALUES(1)
INSERT INTO TB(COL1) VALUES(3)
DELETE TB WHERE COL1 = 3
INSERT INTO TB
VALUES(DBO.F_NEXTBH(), 14)
COMMIT TRAN
GO
SELECT * FROM TB
GO
IF OBJECT_ID('TA') IS NOT NULL
DROP TABLE TA
GO
CREATE TABLE TA(ID INT, COL1 DATETIME)
GO
INSERT INTO TA VALUES(1, GETDATE())
GO
string sql = "select max(cast(replace(serialno,'T','') as int)) from TuiHuoRuKu ";
string serialno = DbHelperSQL.GetMax(sql) + 1).ToString()
StringBuilder strSql = new StringBuilder();
string sql1="insert into TuiHuoRuKu Values(+’”serialno+“‘......................
[/Quote]insert into TuiHuoRuKu
SELECT t.serialno, 字段值2, 字段值3, 字段值4, ...
FROM (
select ISNULL(max(cast(replace(serialno,'T','') as int)),0)+1 serialno
from TuiHuoRuKu
) t