摘要: --增加表cw_users的外键约束fk_users_group,表中的group_id受表cw_users_group中的主键id约束begin transactionalter table cw_users add constraint fk_users_groupforeign key (gr... 阅读全文
posted @ 2015-09-25 23:55 Thinker_cxz 阅读(87) 评论(0) 推荐(0) 编辑
摘要: select * from (select *,ROW_NUMBER() over (order by id) as rowNumfrom cw_diy_scene where category_id = @categoryId ) as tabwhere tab.rowNum between (@... 阅读全文
posted @ 2015-09-25 23:54 Thinker_cxz 阅读(102) 评论(0) 推荐(0) 编辑