SELECT *FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY ID DESC) AS rownum,       FROM TABLE) AS TWHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesizepagenum是当前页,pagesize是每页显示的个数 可以嵌套

首先检查SQL Server 是否开启了SQL SERVER 和 Windows身份验证如果还是不能登陆执行以下SQL代码alter login sa with password = 123456 unlock, check_policy = off, check_expiration = off