>

>HI ALL, 
>              
>My first question , because i want to do a login table but the varbinary is very difficult to handle...
>warning :Msg 402, Level 16, State 1, Procedure spUpdateTwoField, Line 11
>The data types nvarchar and varbinary are incompatible in the add operator.
>
>My code
>Create procedure [dbo].[spUpdateTwoField](@tablename nvarchar(255), @pKey varchar(20), @valueOne varbinary) 
>as 
>	declare @sql nvarchar(4000)
>	set @sql =  'update ' + @tablename + ' set  password = ''' + @valueOne+ ''' where id = ''' + @pKey + ''''
>	execute sp_executesql @sql
>
>	return
>
>-----------------------------------------------------------------------------------------------------
>
>Question Second, i want to know stored procedure can use array ?
>Because my stored procedure , i want to do a update function from array to stored the field name....
>In this code, i already to do a insert function , but all field name store in @Column_List , how can i use array to call ...
>for example ... @Column_List [0], @Column_List [1] to use 
>
>
>

Borislav answered your first question. Take a look at this quite long but very comprehensive artcile for the second question:

Arrays & Lists in SQL Server