Calling a Stored Procedure from a Stored Procedure 
Author Message
 Calling a Stored Procedure from a Stored Procedure

I have an Access Application which I am converting to SQL
Server.

I am hoping to duplicate some code which all the records in
in a table.

The The code is somthing like this

UPDATE Employee SET Password = encrypt(Password)

Here is the encrypt() Function Code.

Private Function encrypt(ByVal aString As String) As String

Dim ndx As Integer, encodedString As String, encodedValue As String

        encodedString = ""
        For ndx = 1 To Len(aString)
            encodedValue = Asc(Mid(aString, ndx, 1)) + 127
            If (encodedValue >= 0) And (encodedValue <= 255) Then
                encodedString = encodedString & Chr(encodedValue)
            End If
        Next

    encrypt = encodedString

End Function

How do I duplicate this functionality in a stored procedure?
Michael Jenkins
Control Tech Consulting Inc.
(905) 790-1507

http://www.***.com/ ~jenkinsm



Mon, 06 May 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Call a stored procedure from another stored procedure

2. Call a stored procedure in another stored procedure

3. Calling a stored procedure by another stored procedure

4. QUESTION: How can I call a Stored Procedure from another Stored Procedure

5. Calling a Stored Procedure from a Stored Procedure

6. Calling a stored procedure within a stored procedure.

7. How do I call a stored procedure from another stored Procedure

8. Calling A Stored Procedure from another Stored Procedure

9. Calling a stored procedure from a stored procedure

10. calling a stored procedure inside a stored procedure

11. Can I call a stored procedure from a stored procedure

12. Calling Java Stored Procedure from SQL Stored Procedure


 
Powered by phpBB® Forum Software