Hello Abdalla,
You can't use funcitons in SQL Server to ecrypt your data but you
can encrypt the data in your application then send it encrypted to SQL.
You can use the appropriate methods in your language to do so. If you need
more information please refer to your language newsgroup.
Kind regards,
Mohamed Sharaf
MEA Developer Support Center
ITWorx on behalf Microsoft EMEA GTSC
--------------------
Content-Class: urn:content-classes:message
From: "Abdallah Jarrar" <***@hotmail.com>
Sender: "Abdallah Jarrar" <***@hotmail.com>
Subject: Encryption
Date: Fri, 23 Jul 2004 14:16:38 -0700
Lines: 9
Message-ID: <305401c470fa$57c43d70$***@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcRw+lfE4scW97YTS5OMU2f75GJYzQ==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.arabic.sqlserver
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.arabic.sqlserver:1204
NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
X-Tomcat-NG: microsoft.public.arabic.sqlserver
Dear Sir;
I would like to know how can I encrypt a field in table in
SQL server 2000 ;
example:
the table is student
the field password
I need the password field data appear like **** in the
database , how can i do it ;
Best Regards