看看这个: -- Test Data: T1 IF OBJECT_ID('T1') IS NOT NULL DROP TABLE T1 Go CREATE TABLE T1(id int identity(1,1),[NAME] NVARCHAR(2) not null primary key) Go INSERT INTO T1(name) SELECT '张三' UNION ALL SELECT '李四' UNION ALL SELECT '王五' UNION ALL SELECT '赵六' GO --Start select * from t1--Result: /* id NAME ----------- ---- 2 李四 3 王五 1 张三 4 赵六*/ --End
再看看这个: -- Test Data: T1 IF OBJECT_ID('T1') IS NOT NULL DROP TABLE T1 Go CREATE TABLE T1(id int identity(1,1),[NAME] NVARCHAR(8) not null primary key) Go INSERT INTO T1(name) SELECT '张三' UNION ALL SELECT '李四' UNION ALL SELECT '王五' UNION ALL SELECT '11赵六' GO --Start select * from t1--Result: /* id NAME ----------- -------- 4 11赵六 2 李四 3 王五 1 张三 */ --End
select max(id) from tb
-- Test Data: T1
IF OBJECT_ID('T1') IS NOT NULL
DROP TABLE T1
Go
CREATE TABLE T1(id int identity(1,1),[NAME] NVARCHAR(2) not null primary key)
Go
INSERT INTO T1(name)
SELECT '张三' UNION ALL
SELECT '李四' UNION ALL
SELECT '王五' UNION ALL
SELECT '赵六'
GO
--Start
select * from t1--Result:
/*
id NAME
----------- ----
2 李四
3 王五
1 张三
4 赵六*/
--End
-- Test Data: T1
IF OBJECT_ID('T1') IS NOT NULL
DROP TABLE T1
Go
CREATE TABLE T1(id int identity(1,1),[NAME] NVARCHAR(8) not null primary key)
Go
INSERT INTO T1(name)
SELECT '张三' UNION ALL
SELECT '李四' UNION ALL
SELECT '王五' UNION ALL
SELECT '11赵六'
GO
--Start
select * from t1--Result:
/*
id NAME
----------- --------
4 11赵六
2 李四
3 王五
1 张三
*/
--End