Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
 Posted - 2011-05-03 : 09:44:11
|
| hI,CAN U TEL ME WHAT IS THE PROB WITH THIS,if specify path directly it works but if pass parameter it dosnt why.ALTER PROCEDURE [dbo].[fts_test1]@path varchar(100)ASBEGIN--set @path= N''''+@path+''''print @path INSERT INTO dbo.fts_test(data)SELECT * FROM OPENROWSET( BULK ''' + @path ''', SINGLE_BLOB) AS MYTABLEEND thanks |
|
|
|
|
|
sQL ERROR