![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL Server
JianfeiMa
Code And Philosophy
展开
-
SQL Server 2005 批量插入数据的语法
insert into employee_privileges ( groupid, form_function, generalpl, remark )select 'root', 'BigData', 1, '大数据'union allselect 'DDdirector', 'BigData', 1, '大数据'union allselect 'CSdirector', 'BigData', 1, '大数据'原创 2021-01-09 09:42:26 · 451 阅读 · 0 评论 -
SQL Server实现分页
SQL Server实现分页SELECT TOP (3) id, remarkFROM dbo.test_page_indexWHERE (id NOT IN (SELECT TOP (3 * (页下标索引-1)) id FROM dbo.test_page_index AS test_page_index_1 ...原创 2020-11-19 19:29:55 · 248 阅读 · 0 评论