![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
猪猪恶霸
这个作者很懒,什么都没留下…
展开
-
sql行专列
WITH temp AS ( SELECT r.update_time, r.name, u.real_name FROM sys_role r LEFT JOIN sys_role_users ru ON ru.role_id = r.id LEFT JOIN sys_user u ON ru.user_id = u.id ) SELECT t0.name, STUFF( ( SELECT ',' + t1.real_name FROM temp原创 2021-04-27 10:56:01 · 154 阅读 · 0 评论 -
多表联合查询和子查询
select corp_name,uni_sc_id,establish_date,reg_capital, concat(datediff(year, trd_start_date,trd_end_date),'年') as validBusinessDate , reg_organ,industry_code,person_name, person_cert_code,address,business_address,area_exercise, d1.label as corpType, d2.la原创 2021-04-15 16:59:02 · 102 阅读 · 0 评论 -
sqlserver 存储过程
----SQL使用游标循环修改数据 DECLARE @code varchar(255), @id varchar(max) --定义参数 DECLARE My_Cursor CURSOR --定义游标 FOR (SELECT id ,code FROM t_category WHERE len(code) > 1 and len(code) < 4 ) --WHERE --查出需要的集合放到游标中 OPEN My_Cursor; --打开游标 FETCH NEXT FROM My_C原创 2021-04-15 15:24:11 · 129 阅读 · 0 评论