62,243
社区成员




declare @SQL varchar(2000)
declare @Order varchar(50)
declare @Line int
set @Order='U_ID'
set @Line=0
set @SQL = 'select top(10) * from User_View where U_Line=@Line And U_ID NOT IN
(
select top(0) U_ID from Users where U_Line=@Line order by '+str(@Order)+' desc
) order by '+str(@Order)+' desc'
exec(@SQL)