摘要：
窗口函数累加递增 select a.OrderNum,a.num,a.CreateTime,b.audittime, sum(a.num) over(order by a.OrderNum range between unbounded preceding AND CURRENT ROW) as c 阅读全文
摘要：
select * from T_YW_Gongdan order by GDCodeoffset 660 rowsfetch next 11 rows only Offset跳过前面的660条数据 fetch next 获取接下来的11条数据 可以用来实现分页获取数据 Sql 2012后支持 阅读全文
摘要：
SELECT 表名 = Case When A.colorder=1 Then D.name Else '' End, 表说明 = Case When A.colorder=1 Then isnull(F.value,'') Else '' End, 字段序号 = A.colorder, 字段名 = 阅读全文
摘要：
nuget中安装Microsoft ASP.NET Web API Cors相关的两个包EnableCors可以在方法 类上用EnableCorsAttibute设置也可以在WebApiConfig的Register方法中，直接config.EnableCors()IIS的设置，在web.confi... 阅读全文
摘要：
转自：http://blogs.microsoft.co.il/blogs/arik/archive/2010/05/28/wpf-single-instance-application.aspxThe ProblemThe question this post solves is how to e... 阅读全文
摘要：
http://mahapps.com/guides/styles.htmlStylesTable of ContentsOverviewHow to change the current theme... via App.xamlHow to change the current theme... ... 阅读全文
摘要：
import datetimeimport copyimport random__TIMES = 0def crs(A,B): return [a+b for a in A for b in B]_DTS = '123456789'_RS = 'ABCDEFGHI'_RU = ('ABC','DEF','GHI')_CS = _DTS_CU = ('123','456','789')_SQS = crs(_RS,_CS)_UL = [crs(_RS,c) for c 阅读全文
