示例35.sql

SQL基础教程上的一些源码

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