摘要:
http://blog.csdn.net/riverlau/article/details/74764491. 使用rownumber给view加上一个标示列SELECT ROW_NUMBER() OVER (ORDER BY appid) AS id, *FROM (SELECT appid, 'NewsLetterService:' + CONVERT(nvarchar(8), id) AS moduleID, ServiceName AS moduleName FROM NewsLetterSe... 阅读全文
posted @ 2014-04-01 08:53
zyip
阅读(357)
评论(0)
推荐(0)

浙公网安备 33010602011771号