select top 10 al.rowid,us.U_UserName, al.L_Contentr,al.L_OpType,al.L_CreateTime from AU_UserBasic as us,
(select ROW_NUMBER() over(order by l_id) as rowid,U_Code, L_Contentr ,L_OpType,L_CreateTime from AU_Log )
select top 10 al.rowid,us.U_UserName, al.L_Contentr,al.L_OpType,al.L_CreateTime from AU_UserBasic as us,
(select ROW_NUMBER() over(order by l_id) as rowid,U_Code, L_Contentr ,L_OpType,L_CreateTime from AU_Log )