Like this
CREATE TABLE [dob].[Customer](
[CustomerID] [int] IDENTITY(1,1) NOT NULL,
[City] [varchar](50) NULL,
[Country] [varchar](50) NULL,
[PostalCode] [nchar](10) NULL,
[Picture] [nvarchar]()
) ON [PRIMARY]
INSERT INTO [dbo].[Customer] --([City], [Country], [PostalCode], [Picture])
VALUES('Oshkosh','USA','54903',0x4F),
('Harlingen','USA','78551',0xCE)
SELECT [CustomerID]
,[City]
,[Country]
,[PostalCode]
,[Picture]
FROM [dbo].[Customer]
GO
CustomerID City Country PostalCode Picture
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1 Oshkosh USA 54903 0x4F
2 Harlingen USA 78551 0xCE
[edit]
DECLARE @strImage nvarchar(888)
SET @strImage = 'c:\users\PT\MyImage.jpg'
DECLARE @strExec [nvarchar](999)
SET @strExec = N'INSERT INTO [dbo].[Customer](Picture) SELECT * FROM OPENROWSET(BULK N''' + @strImage + ''', SINGLE_BLOB) as [imageDedicated]'
EXEC(@strExec)
[end edit]