Thanks for your quick replay.
Now i have issue,i need to pass byte data(scanned image) to procedure parameter, how can i pass this?
my procedure has varbinary(max) parameter how do i pass this value to sp?
My Procedure Is
ALTER PROCEDURE [dbo].[imagematch](@match varbinary(max))
select * from dbo.image where cast(image1 as nvarchar(max))=cast(@match as nvarchar(max))
Please help me out this...
Thanks in advance.