摘要:
declare @PageNumber AS INT, @RowNumber AS INT SET @PageNumber=3 SET @RowNumber=50 SELECT [a].[Id] FROM [AppBooks] AS [a] ORDER BY [a].[Name] OFFSET (( 阅读全文
摘要:
declare @var int set @var=0 while(@var<10000000) begin INSERT INTO [dbo].[AppBooks] ([Id] ,[Name] ,[Type] ,[PublishDate] ,[Price] ,[ExtraProperties] , 阅读全文
摘要:
// 两种获取方法 function GetQueryString(parameter) { var reg = new RegExp("(^|&)" + parameter + "=([^&]*)(&|$)"); var r = window.location.search.substr(1).m 阅读全文
摘要:
【一:行转列】插入临时数据 --插入一下临时数据源 with m as( select '张三' name,'语文'course,'89'score union all select '张三' name,'数学'course,'100'score union all select '张三' name 阅读全文