10 2012 档案

Oracle多行转一行：wmsys.wm_concat、sys_connect_by_path、自定义函数实现行列转换
摘要：构建测试表：create table TABLE1( ID INTEGER, NAME VARCHAR2(10))create table TABLE2( ID INTEGER, ROLE VARCHAR2(10))insert into TABLE1 (ID, NAME) values (1, '张三');insert into TABLE1 (ID, NAME) values (2, '李四');commit;insert into TABLE2 (ID, ROLE) values (1, '查询');insert into TABLE2 ( 阅读全文
posted @ 2012-10-16 19:02 ミ茹此茹此↘ 阅读(528) 评论(0) 推荐(0)
C# EF操作类
摘要：Repository.cs 1 using System; 2 using System.Collections.Generic; 3 using System.Linq; 4 using System.Data; 5 using System.Data.Entity; 6 using Models; 7 using System.Linq.Expressions; 8 using System.Reflection; 9 using System.Web; 10 using System.Data.OracleClient; 11 12 namespace DAL 13 ... 阅读全文
posted @ 2012-10-12 11:51 ミ茹此茹此↘ 阅读(932) 评论(1) 推荐(0)
SQL SERVER TRIGGER
摘要：SQL SERVER TRIGGER 阅读全文
posted @ 2012-10-12 10:30 ミ茹此茹此↘ 阅读(224) 评论(0) 推荐(0)