KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a set of audio files with names GreenLine1.mp3, GreenLine2.mp3 e.t.c. I'm going to write them into a table as BLOB (I use MS SQL Server'08), here's my sql request: 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; I have an error: Incorrect syntax near '+', expecting ',' or ')'. If I try to write 'C:\Users\Ilya\folder\GreenLine' + CAST(@num AS VARCHAR) + '.mp3' into a variable and put it after BULK, I get Incorrect syntax near @variable, expected STRING, or TEXT_LEX
Tags (comma-separated)
Save Edits
Cancel