打赏
摘要: var sql = @"SELECT w2.n, w1.* FROM dbo.[User] w1 RIGHT JOIN (SELECT TOP " + page*rows+ @" row_number() OVER(ORDER BY ID DESC) n, ID FROM dbo.[User]) w 阅读全文
posted @ 2017-04-14 14:43 刘奇云 阅读(317) 评论(0) 推荐(0)
摘要: public string GetNavigationsJson() { AjaxA_NAVIGATIONS ajaxnavigations = new AjaxA_NAVIGATIONS(); IList listnavigations = ajaxnavigations.GetNavigations(); ... 阅读全文
posted @ 2017-04-14 14:37 刘奇云 阅读(355) 评论(0) 推荐(0)
摘要: 准备一些测试数据,如下: use TestCreate table Student(ID int identity(1,1) primary key,[Name] nvarchar(50) not null)Create Table Book(ID int identity(1,1) primary 阅读全文
posted @ 2017-04-14 14:34 刘奇云 阅读(17365) 评论(0) 推荐(0)