回密存儲過程(100分)

F

forjing_888

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #1

各位:
我想把一個存儲過和加密,但是沒有資料,因為我的sql全部是靠幫助學來的,誰可以把我
改下下面的存儲過程,把它加密,好簡單的
CREATE proc cmb
@item char(20)
as
select stk.*,bom.* from stk join bom on stk.partno=bom.partno
where item=@item order by bom.partno
GO

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #2

create proc name @item char(20) with encryption
as

 

E

ericimex01

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #3

CREATE proc cmb
@item char(20)
WITH ENCRYPTION
......

 

F

forjing_888

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #4

多人接受答案了。

 

K

kkyy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #5

with encryption是用于MSSQLSERVER，你用什么数据库？