USE MyCompany
GO
CREATE TABLE LOBTable
(Name nvarchar(60) NULL,
Numb int NOT NULL,
Class nvarchar NULL,
Contents varbinary(max) NULL,
Picture varbinary(max) NULL)
GO

INSERT INTO LOBTable
(Name,Numb,Class,Contents,Picture) 
SELECT 'Peter' AS Name, 
       '21001' AS Numb,
       '72301' AS Class, 
	  * FROM OPENROWSET(BULK 'C:\Peter.txt', SINGLE_BLOB) AS Contents,
       OPENROWSET(BULK 'C:\Peter.JPG', SINGLE_BLOB) AS Picture
GO

SELECT * 
FROM LOBTable


INSERT INTO LOBTable
(Name,Numb,Class,contents,Picture) 
SELECT 'William' AS Name, 
	      '21002' AS Numb,
	      '72301' AS Class, 
* FROM OPENROWSET(BULK 'C:\William.txt', SINGLE_BLOB) AS Contents,
	       OPENROWSET(BULK 'C:\William.JPG', SINGLE_BLOB) AS Picture
GO