SQL Server problem?

xiaoxiao2021-03-06  44

In previous programming, never use to think of SELECT TOP 20 ××, ××, ××× from TableName is not select × ×, ××, ×××× from TableName 20 data.

On the use of the stored procedure, the large amount of data is used, where the general paging stored procedure is used. One day, the customer called, there was a duplicated data, and the past debug found, in the first page, used Select Top 20 ××, ××, ××× from TableName is not Select ××, ××, × ××× from tablename 20, now this problem is debugging, I hope to find problems tomorrow

转载请注明原文地址:https://www.9cbs.com/read-63426.html

New Post(0)