Data Classification: 1
Key Note: (0-Public; 1-Internal; 2-Confidential; 3-Strictly
Confidential)
Ini contoh coding procedurenya :
Create Procedure reg_server With Encryption
As
Declare @servernm varchar(10)
Set @servernm = 'AAAAAAA'
Select @servernm
GO
Ini contoh coding functionnya
CREATE FUNCTION dbo.ufn_AgeCount (@BirthDate datetime , @Today
datetime)
RETURNS integer With Encryption
AS
BEGIN
DECLARE @AgeCount smallint
SET @AgeCount = datediff( yy, @BirthDate, @Today )
RETURN(@AgeCount)
END
Ruby Zanuar Z.
IT-Employee Benefit
PT. Asuransi ALLIANZ Life Indonesia
Summitmas II Lt. 19
Jl. Jend. Sudirman kav 61-62
Jakarta, 12190
Phone : 62-21-52998888 Ext. 2022
Fax : 62-21-52998880, 62-21-30003400
E-mail : [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >
________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Andreas J
Sent: Friday, November 23, 2007 10:04 AM
To: [email protected]
Subject: Re: [indopb] Embedded SQL vs Stored Procedure
Bro Imran, kalau sampai kita & sa ga bisa lihat
kalau perlu diedit gimana donk?
Rgds,
----- Original Message ----
From: imranpunya <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, November 16, 2007 9:30:39 AM
Subject: RE: [indopb] Embedded SQL vs Stored Procedure
Dulu saya pakai MS SQL 2000, yang menyediakan cara untuk menyembunyikan
coding dalam stored procedure dan trigger.
Hasil akhirnya, kita dan sa pun tidak bisa melihat codingnya.
Hanya nama strored procedure dan triggernya yang terlihat.
Caranya tambahkan with encryption di sp nya.
CREATE PROC[EDURE] procedure_name
[;number]
[
[EMAIL PROTECTED] data_type} [= default] [OUTPUT]
]
[,...n]
[WITH {RECOMPILE | ENCRYPTION | RECOMPILE,ENCRYPTIO N}]
AS
sql_statement [...n]
________________________________
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try
it now.
<http://us.rd.yahoo.com/evt=51731/*http://mobile.yahoo.com/sports;_ylt=A
t9_qDKvtAbMuh1G1SQtBI7ntAcJ>
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email in error please notify the system manager. This
message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.
