xp

导航

随笔分类 -  SQL Sever相关知识积累

一句SQL语句的几点解释

摘要：select DueTime=case [PayMentTypeChildSNO] when '0' then (case ProductTypeSNO when '9' then CONVERT(varchar(20),DATEADD(day,30,ProductPurchase.CreateTime),120)/** 整套电视剧**/ else CONVERT(varchar(20),DATE... 阅读全文

posted @ 2007-12-19 11:47 xp 阅读(225) 评论(0) 推荐(0)

数据库行列转换

摘要：数据表：index content num1 hello 11 mr 21 king 32 I 12 am 22 best 32 the 4写出sql语句，得到一下查询结果：查询结果：index content 1 hello mr king2 I am the bestalter function dbo.fun_content(@id int)RETURNSVARCHAR(32) ASbegi... 阅读全文

posted @ 2007-10-22 15:22 xp 阅读(439) 评论(0) 推荐(0)