Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
DECLARE @interestChildId bigint; Declare curApplicationRow Cursor FOR SELECT RchChildId from NewApplication Open curApplicationRow FETCH NEXT FROM curApplicationRow INTO @interestChildId WHILE @@FETCH_STATUS =0 --GO THROUGH EACH RECORD BEGIN SELECT dbo.ResearchInterests.Name as interestName, dbo.ResearchInterests.ParentResearchInterest_id as parentId from dbo.ResearchInterests WHERE dbo.ResearchInterests.Id = @interestChildId WHILE(parentId <> NULL)--USE THE PARENTID TO TRAVERSE TO ITS PARENT NODE UNTIL REACHES ROOT NODE BEGIN @interestChildId = parentId SELECT dbo.ResearchInterests.Name, dbo.ResearchInterests.ParentResearchInterest_id as parentId from dbo.ResearchInterests WHERE dbo.ResearchInterests.Id = @interestChildId END FETCH NEXT FROM curApplicationRow INTO @interestChildId END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.