![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql技术
码农泡上白富美
热爱IT事业
展开
-
JDBC数据库连接
public static void main(String[] args) { BaseDao dao = new BaseDao(); Connection conn = dao.fanHuiShuJuKuLianJie(); PreparedStatement pretmt = null; ResultSet rs =原创 2012-06-03 21:44:52 · 365 阅读 · 0 评论 -
sql游标001
-- 申明游标 declare cursor_001 cursor for select DICT_CODE,DICT_DESCRIBE,DICT_VALUE from @variable_Table -- 开启游标 open cursor_001 fetch next from cursor_001原创 2012-06-03 21:43:51 · 351 阅读 · 0 评论 -
行转列
--创建临时表,将查出的数据插入临时表 declare @tm_staticTable table(children int,tdtname varchar(255),stand_tdt varchar(255),cycle varchar(255)); insert into @tm_staticTable (children,tdtname,stand_tdt,cycle) select原创 2012-05-18 16:26:38 · 747 阅读 · 0 评论 -
查询合并由烦到简三种写法
一、原始 写法 select a.tdtname,b.num,c.num from (select tdtname from dbo.IKNOW_STATISTICS_U2000V1R7C00 where type='TDT') a left join ( select tdtname,count(*) as num from dbo.IKNOW_STORY_U2000V1R7C原创 2012-05-22 18:16:18 · 456 阅读 · 0 评论 -
sql 知识点杂技
一、ROW_NUMBER 语法:ROW_NUMBER ( ) OVER ( [ ] ) 事例:select row_number() over (order by dict_type_id) ,* from E3_DICT_TYPE原创 2012-06-13 08:52:40 · 284 阅读 · 0 评论 -
sql 创建临时表的两种写法和删除临时表
--创建、删除临时表 --第一种方式 create table #tmp(name varchar(255),id int) --第二种方式 select count(id) as storyNum , sum(convert(numeric(10,2),case when isnumeric(code)=1 then code else 0 end)) as codeNum, sum((c原创 2012-06-15 17:07:24 · 6033 阅读 · 0 评论