多表时专题

sql2005 联查多表时自动ID段

select * from (SELECT  row_number() over(order by id desc) as rowid,    [id]       ,[PureKeys]       ,[PrintCount]       ,[PrintState]       ,[HostName]       ,[Remark]       ,[PrintUs