Hi,
I'm trying to do a pretty simple concatenation in a stored procedure, but from some reason it doesn't work:
please help!
DROP PROC Temp;
GO
CREATE PROC Temp
(
@SearchStr nvarchar(100)
)
AS
BEGIN
SET NOCOUNT ON
DECLARE Eli_Cursor CURSOR FOR
Select Name1
From [Northwind].[dbo].[Eli];
Declare @FileName nvarchar(40);
Declare @tmp nvarchar(40);
SET @FileName = '';
SET @tmp = ''
OPEN Eli_Cursor;
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM Eli_Cursor INTO @FileName;
SET @tmp = @FileName+'.jpg';
update [Northwind].[dbo].[Eli]
set Name3 = @tmp
where Name1 = @FileName;
END
CLOSE Eli_Cursor;
DEALLOCATE Eli_Cursor;
END
go