歪头儿在帝都

摘要： 在报表中遇到一个查询问题： 原始数据如下:Id cust_id call_date call_result1 1 2012-03-15 09:00:00 fail2 1 2012-03-15 09:05:00 number error3 1 2012-03-15 09:10:00 fail4 1 2012-03-15 09:15:00 success5 2 2012-03-15 09:01:00 fail6 2 2012-03-15 09:06:00 number error7 2 2012-03-15 09:17:00 fail8 2 2012-03-15 ... 阅读全文

摘要： create table a( id int identity(1,1), area varchar(20), da1 int, da2 int, da3 int, db1 int, db2 int, db3 int )insert into a values ('北京',1,2,3,4,5,6)insert into a values ('上海',7,8,9,10,11,12)select * from a unpivot(num for Cols in (da1,da2,da3,db1,db2,db3)) a drop table a 阅读全文

摘要： create table tb(姓名 varchar(10),课程 varchar(10),分数 int)insert into tb values('张三','语文',74)insert into tb values('张三','数学',83)insert into tb values('张三','物理',93)insert into tb values('李四','语文',74)insert into tb values('李四','数学& 阅读全文

摘要： 引用类库:Newtonsoft.Json序列化原型：string json = JavaScriptConvert.SerializeObject(object value);List<Student> lists =new List<Student>(); lists.Add(new Student{ ID=1, Name="Sword", Age=26}); String str = JavaScriptConvert.SerializeObject(lists);反序列化原型:object obj = JavaScriptConvert.Des 阅读全文

摘要： create proc p_sword_getblcolumn(@tblName varchar(200),@fromIndex int,@toIndex int,@columnName varchar(3000) output)as begin declare @tempColumn varchar(3000) declare @errMsg varchar(200) declare @i int set @i=1 set @columnName='' set @errMsg='' declare tempColumnCur cursor for select 阅读全文

摘要： 1、STUFF作用删除指定长度的字符，并在指定的起点处插入另一组字符。2、语法STUFF ( character_expression , start , length ,character_expression )3、示例以下示例在第一个字符串 abcdef 中删除从第 2 个位置（字符 b）开始的三个字符，然后在删除的起始位置插入第二个字符串，从而创建并返回一个字符串SELECT STUFF('abcdef', 2, 3, 'ijklmn')GO结果集：aijklmnef 阅读全文

摘要： select * from (select '2011-09-14' as sign_date,'2011-09-01' as issu_dateunionselect '2011-09-10' as sign_date,'2011-09-05' as issu_dateunionselect '2011-09-12' as sign_date,'2011-09-02' as issu_dateunionselect '' as sign_date,'2011-09-04&# 阅读全文