?? 示例35.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
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -