导航

03 2019 档案

MERGE INTO

摘要：USE tempdb; GO IF OBJECT_ID('SourceTable') IS NOT NULL DROP TABLE SourceTable; IF OBJECT_ID('TargetTable') IS NOT NULL DROP TABLE TargetTable; --源 CREATE TABLE SourceTable ( id INT, ... 阅读全文

posted @ 2019-03-22 10:19 yiyishuitian 阅读(183) 评论(0) 推荐(0)

事务回滚 try catch

摘要：USE tempdb IF OBJECT_ID ('dbo.test') IS NOT NULL DROP TABLE dbo.test GO CREATE TABLE dbo.test ( id INT NOT NULL, CONSTRAINT pk_id PRIMARY KEY (id) ) GO BEGIN TRY BEGIN TRANSACT... 阅读全文

posted @ 2019-03-19 11:17 yiyishuitian 阅读(195) 评论(0) 推荐(0)

事务回滚 SET XACT_ABORT ON

摘要：USE tempdb IF OBJECT_ID ('dbo.test') IS NOT NULL DROP TABLE dbo.test GO CREATE TABLE dbo.test ( id INT NOT NULL, CONSTRAINT pk_id PRIMARY KEY (id) ) GO BEGIN TRANSACTION INSE... 阅读全文

posted @ 2019-03-19 11:12 yiyishuitian 阅读(194) 评论(0) 推荐(0)

EXT 获取gird各值

摘要：var grid = App.mygridpanel; columns.push(list.dataIndex); } } var columnsjson = JSON.stringify(columns); 阅读全文

posted @ 2019-03-14 09:35 yiyishuitian 阅读(389) 评论(0) 推荐(0)

SQL FOR JSON PATH 返回 json

摘要：--直接返回 SELECT '张学友' name, 60 age FOR JSON PATH --返回值 [{"name":"张学友","age":60}] select c1, c2 from table FOR JSON PATH --带子集 SELECT '张学友' name, 60 age,'你好毒' AS [专辑.流行],'如果这都不算爱' AS [专辑.经典] ... 阅读全文

posted @ 2019-03-11 18:44 yiyishuitian 阅读(2302) 评论(0) 推荐(0)

C# 创建Datatable 并插入数据

摘要：DataTable dt_temp = new DataTable(); dt_temp.Columns.Add("id"); dt_temp.Columns.Add("name"); for (int i = 0; i < 10; i++) { DataRow dr = dt_temp.... 阅读全文

posted @ 2019-03-07 15:24 yiyishuitian 阅读(876) 评论(0) 推荐(0)

SQL 生日得到年龄

摘要：CREATE FUNCTION ufn_hr_getagefrombirthday ( @birthday DATE, @now DATE =NULL ) RETURNS VARCHAR(20) BEGIN IF (@now IS NULL OR @now = '') BEGIN ... 阅读全文

posted @ 2019-03-04 08:59 yiyishuitian 阅读(235) 评论(0) 推荐(0)