Sort rows in SQL Server Table View edit mode

kankon
 
on Aug 25, 2021 10:48 PM
687 Views

hello , 

i have table in sql server with id number auto increment

1

2

14

154

5

4

654

3

can i fix this ?

i want it like 1,2,3,4,5,6....

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Aug 26, 2021 07:51 AM
on Aug 27, 2021 03:30 AM

In editor you can't change this. You need to either take backup of all the records and truncate table and re-insert by ordering.

Or you need to use order by in your query to display the records.