SQL 自增插入
INSERT INTO T2(ID,TID,NAME)
VALUES(
(SELECT CASE WHEN (MAX(ID)) IS NULL THEN 0
ELSE (MAX(ID)+1)
END
FROM T2
WHERE TID='@TID'
),
'CANDY',
'@TID')
SQL 自增插入
INSERT INTO T2(ID,TID,NAME)
VALUES(
(SELECT CASE WHEN (MAX(ID)) IS NULL THEN 0
ELSE (MAX(ID)+1)
END
FROM T2
WHERE TID='@TID'
),
'CANDY',
'@TID')