sql server
秋天的云QQ
码农,一定要坚持码起来
展开
-
sqlserver 树形结构查询,单表
--树形sql查询WITH TREE AS( --创建一个虚拟表 SELECT * FROM sys_organiz --指定需要查询的表 WHERE organize_code = '100000' -- 指定父节点条件 UNION ALL --联合查询 SELECT sys_organiz.* FROM sys_organiz,TREE原创 2017-08-18 10:42:01 · 4627 阅读 · 1 评论 -
通过sqlserver Management 导入导出数据
无法在只读列“id”中插入数据原创 2017-07-25 16:50:38 · 9338 阅读 · 1 评论 -
mybatis +junit4 +maven
1、junit4 测试插入数据时回滚@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration(locations = { "classpath:spring-mvc.xml", "classpath:spring-ctx-mybatis.xml", "classpath:spring-ctx-shiro.xml" })pu原创 2017-08-13 00:14:45 · 418 阅读 · 0 评论 -
mybatis 动态SQL '@P0' 附近有语法错误
1、mybatis动态SQL遇到的问题org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: java.sql.SQLException: “@P0”附近有语法错误。### The error may exist in file [E:\DevelopTools\Ecli原创 2017-08-14 15:31:29 · 3107 阅读 · 0 评论 -
Sql Server Sql语句学习
begintransaction begin try deletefrom sys_permission_menu where permission_code= #{permission_code}; insertinto sys_permission_menu(permission_code, menu_code) select #{原创 2017-09-10 11:05:59 · 202 阅读 · 0 评论 -
sql server 每日一记之 with as delete from where in (select)
with cte as(select a.menu_code,a.menu_name,a.menu_parent_codefrom sys_menu a where menu_code=#{menu_code}unionallselect k.menu_code,k.menu_name,k.menu_parent_codefrom sys_menu k inner jo原创 2017-09-11 09:44:41 · 3110 阅读 · 0 评论 -
mybaits nor a Result Map was specified,以及transcation对应的@Transcational
org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.project.modules.admin.dao.mapper.SysRolePermissionMapper.UpdatePermissionByRol原创 2017-09-11 15:04:08 · 341 阅读 · 0 评论