随笔分类 -  sqlserver

sqlserver跨服务器数据库sql语句
摘要：1、启用Ad Hoc Distributed Queries：exec sp_configure 'show advanced options',1reconfigureexec sp_configure 'Ad Hoc Distributed Queries',1reconfigure2、sql语 阅读全文
posted @ 2016-03-24 13:14 梦锁湘江 阅读(273) 评论(0) 推荐(0)
sql分页代码
摘要：//三种sql分页语句SELECT TOP 分页尺寸 *FROM ( SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM Blobs ) AWHERE RowNumber > 分页尺寸*(页数... 阅读全文
posted @ 2014-11-18 14:06 梦锁湘江 阅读(124) 评论(0) 推荐(0)