使用SQL語句從電腦導入圖片到數據庫的方法，具體代碼如下所示：

–創建圖片表
CREATE TABLE W_PIC
(
ID INT, –編號
WPATH VARCHAR(80), –完整路徑
PIC VARCHAR(80), –圖片名稱，不帶后綴
img image –圖片內容
)
–圖片表中插入數據
INSERT INTO W_PIC(ID,WPATH,PIC)
SELECT 1, ‘C:UserswDesktop產品圖片2#加工圖34-C專用.jpg’,’2#加工圖34-C專用’
UNION ALL
SELECT 2, ‘C:UserswDesktop產品圖片129.jpg’,’129′
–創建游標
DECLARE CUR_PIC CURSOR FOR SELECT ID,WPATH,PIC FROM W_PIC;
DECLARE @ID int, @PATH VARCHAR(80), @PIC VARCHAR(80), @STR VARCHAR(100);
OPEN CUR_PIC;
FETCH NEXT FROM CUR_PIC INTO @ID, @PATH, @PIC;
WHILE @@FETCH_STATUS=0
BEGIN
SET @STR=STR(@ID);
–插入圖片數據
EXECUTE (‘UPDATE W_PIC SET img=(SELECT * FROM OPENROWSET(BULK N”’+@PATH+”’, SINGLE_BLOB) AS Photo) WHERE ID=’+@STR);
FETCH NEXT FROM CUR_PIC INTO @ID, @PATH, @PIC;
END
CLOSE CUR_PIC;
DEALLOCATE CUR_PIC;