我有一组音频文件,名称为GreenLine1.mp3,GreenLine2.mp3等。我将把它们作为BLOB写入表中(我使用MS SQL Server'08),以下是我的SQL请求:
DECLARE @aud AS VARBINARY(MAX)
DECLARE @num AS INT
-- Load the audio data
SET @num=1
WHILE (@num<38)
BEGIN;
SELECT @aud = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK
'C:\Users\Ilya\folder\GreenLine' + CAST(@num AS VARCHAR) + '.mp3',
SINGLE_BLOB ) AS x
-- Insert the data to the table
INSERT INTO Mb2.dbo.Audios (Id, [Content])
SELECT NEWID(), @aud
SET @num = @num + 1
END;
我遇到一个错误:在'+'附近有语法错误,需要','或')'。
如果我尝试将
'C:\Users\Ilya\folder\GreenLine' + CAST(@num AS VARCHAR) + '.mp3'
写入一个变量,并将它放在BULK后面,我会得到“在@变量附近有语法错误,期望是STRING或TEXT_LEX”。