Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @tab TABLE (ID INT IDENTITY, Name VARCHAR(10), Seq INT)
- INSERT INTO @tab VALUES('A',1),('B',1),('C',1),('D',3),('E',4),('F',5),('G',6),('H',7),('I',8)
- SELECT * FROM @tab ORDER BY Seq
- DECLARE @tab TABLE (ID INT IDENTITY, Name VARCHAR(10), Seq INT)
- INSERT INTO @tab VALUES('A',4),('B',5),('C',6),('D',7),('E',8),('F',9),('G',1),('H',2),('I',3)
- SELECT * FROM @tab ORDER BY Seq
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement