求帮助



set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE  [dbo].[adduser]

@name               varchar(64),
@passwd            binary(16),
@prompt            varchar(32),
@answer            varchar(32),
@truename        varchar(32),
@idnumber        varchar(32),
@email               varchar(64),
@mobilenumber varchar(32),
@province         varchar(32),
@city                 varchar(32),
@phonenumber  varchar(32),
@address            varchar(64),
@postalcode       varchar(8) ,
@gender             integer,
@birthday          varchar(32),
@qq                   varchar(32),
@passwd2         binary(16)

AS

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON
SET NOCOUNT ON
SET XACT_ABORT  ON

    BEGIN TRAN
    DECLARE @id integer
    SELECT @id = ISNULL(max(id), 16) + 16 FROM users HOLDLOCK
    INSERT INTO users (id,name,passwd,prompt,answer,truename,idnumber,email,mobilenumber,province,city,phonenumber,address,postalcode,gender,birthday,creatime,qq,passwd2) VALUES( @id, @name, @passwd, @prompt, @answer, @truename, @idnumber, @email, @mobilenumber, @province, @city, @phonenumber, @address, @postalcode, @gender, @birthday, getdate(), @qq, @passwd2 )
    COMMIT TRAN


这是存储过程!

exec adduser 'admin','fedr543hyd6124fc','1','1','1','2','1','1','1','1','1','1','1','1','2010-01-10','123','fedr543hyd6124fc'

我存储时叫我用convert转换


exec adduser 'admin',convert(binary,'fedr543hyd6124fc'),'1','1','1','2','1','1','1','1','1','1','1','1','2010-01-10','123',convert(binary,'fedr543hyd6124fc')


但是我转换后 又提式我convert语法有错误!


给分50   谢谢们 请大家帮帮忙....

select convert(binary,'fedr543hyd6124fc')
结果
0x666564723534336879643631323466630000000000000000000000000000

convert()将内容转换到所指定的格式
convert(binary,'fedr543hyd6124fc')把'fedr543hyd6124fc'当作十六进制转成二进制，转换之后位数会很长，用十六进制表示出来
 @passwd2         binary(16)    这个是16位二进字，数据类型太短了，所以肯定不能将convert(binary,'fedr543hyd6124fc')的结果赋给它啦
你改变一下它的数据类型，一般密码都是字符型 的啊
数据库表的users 的passwd2字段的数据类型也要注意一下，如果错了也插入不了的