Identity

[chautinhtri]

Tạo cột có kiểu Identity bằng lệnh SELECT

IDENTITY (data_type [ , seed , increment ] ) AS column_name

SELECT IDENTITY (INT, 1, 1) AS Id
INTO ...
FROM ...:

Chú ý: Bắt buộc phải INTO vào một bảng nào đó

:eek:

[Libra307]

IF OBJECT_ID('Tempdb..#Temp') IS NOT NULL DROP TABLE #Temp
CREATE TABLE #Temp(Auto_Code Int IDENTITY(1,1), Stt CHAR(1))
INSERT INTO #Temp(Stt) VALUES('1')
INSERT INTO #Temp(Stt) VALUES('3')
INSERT INTO #Temp(Stt) VALUES('4')
SELECT * FROM #Temp

[TrungBravo]

DECLARE @TableTemp TABLE (Auto_Code Int IDENTITY(1,1), Stt CHAR(1))

INSERT INTO @TableTemp (Stt) VALUES('4')
INSERT INTO @TableTemp (Stt) VALUES('3')
INSERT INTO @TableTemp (Stt) VALUES('2')
INSERT INTO @TableTemp (Stt) VALUES('1')

INSERT INTO @TableTemp (Stt) SELECT Stt FROM @TableTemp ORDER BY Stt

SELECT * FROM @TableTemp