摘要：
DECLARE @table TABLE( id INT IDENTITY, CreateDate DATE); INSERT INTO @table( CreateDate)SELECT '2020-06-07'--上周日UNION ALLSELECT '2020-06-08'--本周一UNION 阅读全文
摘要：
//定义树实体类 public class CityTreeView { public int id { get; set; } public int ParentId { get; set; } public string name { get; set; } public List<CityTr 阅读全文
摘要：
--PARTITION BY分组 DECLARE @table TABLE ( code VARCHAR(100) ,name NVARCHAR(100) ) INSERT INTO @table( code ,name)VALUES('张三','aa'),('张三','aa'),('张三','aa 阅读全文
摘要：
DECLARE @table TABLE( id INT NOT NULL ,cityName NVARCHAR(100) ,parentId int NOT null)INSERT INTO @table( id, cityName, parentId)SELECT 1,'湖南省',0 UNION 阅读全文
摘要：
DECLARE @table TABLE( id INT IDENTITY(1,1), name VARCHAR(100) null) INSERT INTO @table( name)SELECT NULL UNION ALLSELECT 'aa' UNION ALLSELECT 'bb' UNI 阅读全文
摘要：
//后台需做并发校验 <div> <button id="ok">确定</button></div><script> $('#ok').on('click', function () { var data = []; data.id=1 $.ajax({ type: "post", data: da 阅读全文