数据插入的方式

1.

CREATE TABLE t
(
    id INT IDENTITY,
    [name] NVARCHAR(10),
    pid INT
)
INSERT t
SELECT N'张三', 0 UNION ALL
SELECT N'李四', 0 UNION ALL
SELECT N'王五', 2
GO
--SQL:
select * from t order by pid desc
select top 5 WITH TIES * from t order by pid DESC
select top 5 * from t order by pid desc

待整理。。