Please HELP.I installed WebPage by Proof for 99.6x ,and when I put in query analizer for muonline :
CREATE FUNCTION [dbo].[fn_md5] (@data VARCHAR(10), @data2 VARCHAR(10))
RETURNS BINARY(16) AS
BEGIN
DECLARE @hash BINARY(16)
EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT
RETURN @hash
END
CREATE PROCEDURE Encript
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS
BEGIN
DECLARE @btOutVal BINARY(16)
EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
END
GO
**********************************************************
Then I press F5 to execute and it gives:
Server: Msg 156, Level 15, State 1, Procedure fn_md5, Line 9
Incorrect syntax near the keyword 'CREATE'.
Server: Msg 111, Level 15, State 1, Procedure fn_md5, Line 9
'CREATE PROCEDURE' must be the first statement in a query batch.
Server: Msg 137, Level 15, State 1, Procedure fn_md5, Line 15
Must declare the variable '@btInStr'.
Server: Msg 137, Level 15, State 1, Procedure fn_md5, Line 16
Must declare the variable '@btInStrIndex'.
**********************************************************
I use SQL evaluation edition -is that the problem?
Here is my website:
You must be registered to see links
-In "Statistic" -shows an error. When press Register -it says: Some fileds were left blank....
Please tell me where is the problem?