Ceiling分页存储过程

/*
EXEC PROC_CeilingPager 1,10
*/
CREATE PROC PROC_CeilingPager
@RowID int,
@PageSize int
AS


SELECT  
ROW_NUMBER() OVER (ORDER BY [userId] desc) AS RowNumber,*
into #dt_data
FROM [OA_USER] WHERE IsEnable=1




;with dt_Page AS(
SELECT 
ceiling(RowNumber*1.0/@PageSize) as RowID,*
FROM #dt_data)


SELECT * FROM dt_Page WHERE RowID=@RowID


DROP TABLE #dt_data


GO

if exists (select * from sysobjects where id = OBJECT_ID('[OA_USER]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) 
DROP TABLE [OA_USER]


CREATE TABLE [OA_USER] (
[userId] [int]  IDENTITY (1, 1)  NOT NULL,
[loginName] [varchar]  (50) NULL,
[loginPassword] [varchar]  (50) NULL,
[userName] [varchar]  (50) NULL,
[mobile] [varchar]  (50) NULL,
[email] [varchar]  (50) NULL,
[fax] [varchar]  (20) NULL,
[tel] [varchar]  (200) NULL,
[areaCode] [int]  NULL,
[deptCode] [int]  NULL,
[hrCode] [int]  NULL,
[address] [varchar]  (200) NULL,
[postcode] [varchar]  (10) NULL,
[myhome] [varchar]  (50) NULL,
[companyId] [int]  NULL,
[IsEnable] [tinyint]  NULL DEFAULT (0),
[IsPublic] [tinyint]  NULL,
[idiograph] [varchar]  (50) NULL,
[province] [varchar]  (50) NULL,
[city] [varchar]  (50) NULL,
[county] [varchar]  (50) NULL,
[cha_id] [int]  NULL,
[if_note] [int]  NULL DEFAULT (0),
[if_to_exam] [int]  NULL,
[level_id] [int]  NULL,
[bbs_Count] [bigint]  NULL DEFAULT (0),
[Revert_Count] [bigint]  NULL DEFAULT (0),
[Last_bbsDate] [datetime]  NULL,
[Last_RevertDate] [datetime]  NULL,
[xyLimit] [decimal]  (38,2) NULL DEFAULT (0),
[bus_cha_id] [int]  NULL)


ALTER TABLE [OA_USER] WITH NOCHECK ADD  CONSTRAINT [PK_OA_USER] PRIMARY KEY  NONCLUSTERED ( [userId] )
SET IDENTITY_INSERT [OA_USER] ON


INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[email],[tel],[deptCode],[postcode],[companyId],[IsEnable],[cha_id],[if_note],[bbs_Count],[Revert_Count],[xyLimit],[bus_cha_id]) VALUES ( 1000,N'admin',N'***',N'管理员',N'[e-mail]',N'0756-2123076',2,N'519000',42,1,17,0,1,0,0.00,1)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[fax],[tel],[areaCode],[deptCode],[hrCode],[postcode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3459,N'kang',N'8276452',N'康凌杰',N'0756-8682383',N'0756-8910263',N'0756-8910616',0,20,0,N'519060',42,0,1,17,-1,-1,-1,-1,-1,N'2007/3/28 9:23:45',N'2007/3/28 9:23:45',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[fax],[tel],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3460,N'yuan',N'1230',N'袁仁素',N'028-87075629',N'028-87076235',N'028-87075629',0,20,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/3/28 9:26:47',N'2007/3/28 9:26:47',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[email],[fax],[tel],[areaCode],[deptCode],[hrCode],[postcode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3461,N'xuan',N'05567200929',N'宣网琴',N'0756-8910615',N'[e-mail]',N'0756-8910263/8917378',N'0756-8910617',0,2,0,N'519060',42,1,1,17,-1,-1,-1,-1,-1,N'2007/3/28 9:27:13',N'2007/3/28 9:27:13',0.00,1)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[fax],[tel],[areaCode],[deptCode],[hrCode],[postcode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3462,N'lynn',N'123456xx',N'张霞',N'0756-8682383',N'0756-8910263',N'0756-8919027',0,2,0,N'519060',42,1,1,1,-1,-1,-1,-1,-1,N'2007/3/28 9:28:00',N'2007/3/28 9:28:00',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[fax],[tel],[areaCode],[deptCode],[hrCode],[postcode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3463,N'xiao',N'456',N'肖惠3463',N'0756-8682383',N'0756-8910263/8682748',N'0756-8915799',0,55,0,N'519060',42,0,1,1,-1,-1,-1,-1,-1,N'2007/3/28 9:28:27',N'2007/3/28 9:28:27',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3465,N'fang',N'password',N'方建',0,2,0,42,1,1,17,-1,-1,-1,-1,-1,N'2007/3/28 9:29:42',N'2007/3/28 9:29:42',0.00,1)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3468,N'hee',N'20131216',N'朱丽芳',0,12,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/3/29 13:09:39',N'2007/3/29 13:09:39',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3469,N'rly',N'660124',N'饶莲英',0,12,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/3/29 13:12:31',N'2007/3/29 13:12:31',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3470,N'huang',N'992211',N'黄艳文',0,12,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/3/29 13:13:44',N'2007/3/29 13:13:44',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3473,N'gsx',N'123',N'赵善星',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/4 18:01:11',N'2007/4/4 18:01:11',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3474,N'lsk',N'123',N'刘信开',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/5 8:56:50',N'2007/4/5 8:56:50',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3475,N'曹恒根',N'001',N'曹恒根',0,16,0,43,1,1,1,-1,-1,-1,-1,-1,N'2007/4/5 8:58:45',N'2007/4/5 8:58:45',300000.00,5)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3476,N'黄招文',N'001',N'黄招文',0,16,0,43,1,1,1,-1,-1,-1,-1,-1,N'2007/4/5 8:59:12',N'2007/4/5 8:59:12',0.00,4)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3477,N'xzc',N'123',N'肖志青',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/5 8:59:45',N'2007/4/5 8:59:45',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3478,N'wxh',N'123',N'王申雄',0,3,0,43,1,1,1,-1,-1,-1,-1,-1,N'2007/4/5 9:00:15',N'2007/4/5 9:00:15',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3479,N'lj',N'123',N'李杰（北京）',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/5 9:00:49',N'2007/4/5 9:00:49',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3480,N'郭海',N'003',N'郭海',0,18,0,44,1,1,1,-1,-1,-1,-1,-1,N'2007/4/5 9:01:17',N'2007/4/5 9:01:17',300000.00,5)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3481,N'lh',N'123',N'刘宽',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/5 9:01:56',N'2007/4/5 9:01:56',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3482,N'tzj',N'123',N'唐志杰',0,20,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/5 9:02:42',N'2007/4/5 9:02:42',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3484,N'lwc',N'123',N'李文强',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/5 9:03:31',N'2007/4/5 9:03:31',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3485,N'叶伟东',N'005',N'叶伟东',0,27,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/4/5 9:03:55',N'2007/4/5 9:03:55',300000.00,4)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3486,N'jbd',N'123',N'朱炳泉',0,20,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/5 9:04:31',N'2007/4/5 9:04:31',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3487,N'jxm',N'123',N'蒋小明',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/5 9:04:57',N'2007/4/5 9:04:57',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[fax],[tel],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3488,N'zhou',N'12345678',N'周一林',N'0756-8910615',N'027-88011349',N'027-88011349',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/18 15:14:24',N'2007/4/18 15:14:24',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3489,N'郭俭雄',N'670818ken',N'郭俭雄',0,24,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/4/18 16:37:31',N'2007/4/18 16:37:31',0.00,4)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3490,N'李田昌',N'12345678',N'李田昌',N'13823075969',0,27,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/4/18 16:42:07',N'2007/4/18 16:42:07',200000.00,5)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3491,N'wzb',N'wzbsicoma',N'www',0,55,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/18 16:43:19',N'2007/4/18 16:43:19',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3492,N'黄景文',N'010',N'黄景文',0,29,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/4/18 16:44:24',N'2007/4/18 16:44:24',300000.00,4)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3493,N'张解军',N'123',N'张解军',N'13709682687',0,36,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/4/18 16:53:10',N'2007/4/18 16:53:10',100000.00,5)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3494,N'yxc',N'123',N'杨新成',N'13570601430',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/18 16:58:24',N'2007/4/18 16:58:24',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3495,N'罗旭阳',N'781010',N'罗旭阳',N'13672704325',0,36,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/4/18 17:00:47',N'2007/4/18 17:00:47',0.00,4)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3496,N'徐富生',N'010',N'徐富生',N'13928010706',0,29,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/4/18 17:04:12',N'2007/4/18 17:04:12',250000.00,5)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3497,N'fzs',N'123',N'范仲生',N'13825608522',0,2,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/4/18 17:04:55',N'2007/4/18 17:04:55',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3498,N'dwx',N'123',N'邓伟雄',N'13928017482',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/18 17:05:41',N'2007/4/18 17:05:41',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3499,N'wcm',N'123',N'吴常茫',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/18 17:06:12',N'2007/4/18 17:06:12',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[tel],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3500,N'yww',N'123',N'严文武',N'13702762100',N'2008-9-1公司不予续签合同',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/4/18 17:07:10',N'2007/4/18 17:07:10',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3501,N'曾桂林',N'001',N'曾桂林',N'13926931472',0,16,0,43,1,1,1,-1,-1,-1,-1,-1,N'2007/4/18 17:07:51',N'2007/4/18 17:07:51',500000.00,5)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3502,N'贾允',N'670',N'贾允',N'13823009619',0,14,0,43,1,1,1,-1,-1,-1,-1,-1,N'2007/4/18 17:09:20',N'2007/4/18 17:09:20',170000.00,4)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3503,N'刘小成',N'12345678',N'刘小成',N'13825661253',0,27,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/4/18 17:10:03',N'2007/4/18 17:10:03',300000.00,5)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3504,N'shi',N'1518',N'史晓敏',0,2,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/5/16 11:06:14',N'2007/5/16 11:06:14',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[mobile],[fax],[tel],[areaCode],[deptCode],[hrCode],[postcode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3505,N'quan',N'123',N'权艳娟',N'0756-8682383',N'0756-8910263',N'0756-8919887',0,13,0,N'519060',42,0,1,1,-1,-1,-1,-1,-1,N'2007/6/18 12:55:31',N'2007/6/18 12:55:31',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3507,N'吴丁喜',N'006',N'吴丁喜',0,41,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/6/30 10:03:27',N'2007/6/30 10:03:27',100000.00,4)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3508,N'何文东',N'007',N'何文东',0,26,0,42,1,1,1,-1,-1,-1,-1,-1,N'2007/6/30 10:04:02',N'2007/6/30 10:04:02',185500.00,5)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3509,N'zj',N'123',N'周骏',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/7/6 18:12:29',N'2007/7/6 18:12:29',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3510,N'wg',N'123',N'王刚',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/7/6 18:13:18',N'2007/7/6 18:13:18',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3511,N'zxh',N'123',N'朱兴恒',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/7/6 18:14:00',N'2007/7/6 18:14:00',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3512,N'lzg',N'123',N'蓝振军',0,13,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/7/6 18:14:41',N'2007/7/6 18:14:41',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3513,N'lyk',N'123',N'兰言坤',0,20,0,42,0,1,1,-1,-1,-1,-1,-1,N'2007/7/6 18:15:22',N'2007/7/6 18:15:22',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3514,N'龙建',N'001',N'龙建',0,16,0,43,1,1,1,-1,-1,-1,-1,-1,N'2007/7/6 18:16:03',N'2007/7/6 18:16:03',400000.00,5)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3515,N'宣新华',N'003',N'宣新华',0,18,0,44,1,1,1,-1,-1,-1,-1,-1,N'2007/7/6 18:17:25',N'2007/7/6 18:17:25',300000.00,5)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3516,N'杨雪松',N'003',N'杨雪松',0,18,0,44,1,1,1,-1,-1,-1,-1,-1,N'2007/7/6 18:18:00',N'2007/7/6 18:18:00',500000.00,4)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3517,N'mxd',N'123',N'马旭东',0,19,0,44,1,1,1,-1,-1,-1,-1,-1,N'2007/7/6 18:18:37',N'2007/7/6 18:18:37',0.00,7)
INSERT [OA_USER] ([userId],[loginName],[loginPassword],[userName],[areaCode],[deptCode],[hrCode],[companyId],[IsEnable],[IsPublic],[cha_id],[if_note],[if_to_exam],[level_id],[bbs_Count],[Revert_Count],[Last_bbsDate],[Last_RevertDate],[xyLimit],[bus_cha_id]) VALUES ( 3518,N'高兴',N'003',N'高兴',0,18,0,44,1,1,1,-1,-1,-1,-1,-1,N'2007/7/6 18:19:09',N'2007/7/6 18:19:09',200000.00,5)
SET IDENTITY_INSERT [OA_USER] OFF










GO

--drop table [OA_USER]
--drop proc PROC_CeilingPager