示例35.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 31 行

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