Short SQL Cursor Script to read or update Data from a set of values using cursor.

DECLARE @URL as NVARCHAR(150);
DECLARE @LangCode as NVARCHAR(30);
DECLARE @Collection as NVARCHAR (50);
DECLARE @ParentID as INT;

DECLARE @PageContentID as INT;
DECLARE @PageContentTitle as NVARCHAR (50);
DECLARE @ApplicationID as INT;
DECLARE @LanguageID as INT;
DECLARE @PageID as INT;


DECLARE @EasyWebCursor as CURSOR;
 
SET @EasyWebCursor = CURSOR FOR
SELECT ID, Title, Application_ID, Language_ID, Page_ID FROM EasyWeb_PageContent
WHERE Content LIKE '%wf-slider%'
 
OPEN @EasyWebCursor;
FETCH NEXT FROM @EasyWebCursor INTO @PageContentID, @PageContentTitle, @ApplicationID, @LanguageID, @PageID;
 
WHILE @@FETCH_STATUS = 0
BEGIN
 SELECT @URL = WebsiteUrl FROM EasyWeb_GeneralSettings WHERE Application_ID = @ApplicationID;
 IF (@URL is null or @URL = '')
     BEGIN
		DECLARE @ApplicationName as NVARCHAR(50);
		SELECT @ApplicationName = Name FROM Applications WHERE ID = @ApplicationID;
		print @ApplicationName + ' has no Website Url';
	 FETCH NEXT FROM @EasyWebCursor INTO @PageContentID, @PageContentTitle, @ApplicationID, @LanguageID, @PageID;
	 END
	 
ELSE   
	BEGIN
	 SELECT @LangCode = Code FROM EasyWeb_Language WHERE ID = @LanguageID;

	 SELECT @ParentID = ParentPage_ID FROM EasyWeb_Page WHERE ID = @PageID;
	 IF (@ParentID = null Or @ParentID = 0)
	  BEGIN
	   PRINT @URL + '/' + @LangCode + '/' + @PageContentTitle;
	  END
	ELSE
	 BEGIN
	 SELECT @Collection = Title FROM EasyWeb_PageContent WHERE Page_ID = @ParentID AND Language_ID = @LanguageID;
	 PRINT @URL + '/' + @LangCode + '/'  + @Collection + '/' + @PageContentTitle;

	 END
	 
	 FETCH NEXT FROM @EasyWebCursor INTO @PageContentID, @PageContentTitle, @ApplicationID, @LanguageID, @PageID;
	END
END
 
CLOSE @EasyWebCursor;
DEALLOCATE @EasyWebCursor;