>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 > > >You can't concatenate different types.
CREATE PROCEDURE [dbo].[spUpdateTwoField] (@tablename nvarchar(255), @pKey varchar(20), @valueOne varbinary) as BEGIN declare @sql nvarchar(4000) set @sql = 'update ' + @tablename + ' set password = @valueOne where id = @pKey' execute sp_executesql @sql, N'@valueOne varbinary, @pKey varchar(20)', @valueOne, @pKey END