if exists(select name from sysobjects  where name='用戶權(quán)限_proc' AND TYPE='P' )
DROP PROC 用戶權(quán)限_proc
go
CREATE PROC 用戶權(quán)限_proc
@use_to varchar(10),
@use_fr varchar(10)
AS
CREATE TABLE [#用戶權(quán)限] (
	[用戶編碼] [varchar] (10),
	[口令] [varchar] (20),
	[增加采購(gòu)單] [char] (1)DEFAULT (1),
	[刪除采購(gòu)單] [char] (1) DEFAULT (1),
	[修改采購(gòu)單] [char] (1)DEFAULT (1),
	[瀏覽采購(gòu)單] [char] (1) DEFAULT (1),
	[增加銷售單] [char] (1) DEFAULT (1),
	[刪除銷售單] [char] (1) DEFAULT (1),
	[修改銷售單] [char] (1) DEFAULT (1),
	[瀏覽銷售單] [char] (1) DEFAULT (1),
	[增加庫(kù)存單] [char] (1)  DEFAULT (1),
	[刪除庫(kù)存單] [char] (1)  DEFAULT (1),
	[修改庫(kù)存單] [char] (1) DEFAULT (1),
	[瀏覽庫(kù)存單] [char] (1)DEFAULT (1),
	[增加物料主文件] [char] (1) DEFAULT (1),
	[刪除物料主文件] [char] (1)  DEFAULT (1),
	[修改物料主文件] [char] (1)  DEFAULT (1),
	[瀏覽物料主文件] [char] (1)  DEFAULT (1),
	[增加應(yīng)付賬] [char] (1) DEFAULT (1),
	[刪除應(yīng)付賬] [char] (1) DEFAULT (1),
	[修改應(yīng)付賬] [char] (1) DEFAULT (1),
	[瀏覽應(yīng)付賬] [char] (1) DEFAULT (1),
	[增加應(yīng)收賬] [char] (1)  DEFAULT (1),
	[刪除應(yīng)收賬] [char] (1)  DEFAULT (1),
	[修改應(yīng)收賬] [char] (1)   DEFAULT (1),
	[瀏覽應(yīng)收賬] [char] (1) DEFAULT (1))

insert into #用戶權(quán)限 select *from 用戶權(quán)限
where 用戶編碼>=@use_to  and 用戶編碼<= @use_fr
select * from #用戶權(quán)限