摘要:
1. 表结构一样 insert into 表1 select * from 表2 2. 表结构不一样( insert into sys_user_role(user_id,role_id)(select user_id,2 from sys_user) ) insert into sys_dept_ 阅读全文
摘要:
-- 分页查询(通用型) select top pageSize * from (select row_number() over(order by sno asc) as rownumber,* from student) temp_row where rownumber>((pageIndex- 阅读全文