DECLARE @strContent nvarchar(8000) SET @strContent = N'' SELECT @strContent = @strContect + content FROM cache WHERE id=@random SELECT @strContent