34,587
社区成员
发帖
与我相关
我的任务
分享
declare @t table(ID int ,PID int)
insert into @t select 1,3
insert into @t select 1,2
select * from @t
--按PID升序插入
select * into yourt from @t order by PID
select * from yourt
insert into t select * from t order by PID
TRUNCATE t
--删除表中所有数据