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 @XML AS varchar(MAX) SET @XML='<root> <Person> <Name>john</Name> <age>14</age> <description>some description</description> <description>the description <outsideContent>the content</outsideContent> continued</description> </Person> <Person> <Name>alex</Name> <age>14</age> <description>Alexs description</description> </Person> </root> ' SELECT CAST(@XML as XML).value( '(root/Person/description)', ' varchar(2000) ' )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL query to select one row with min and max date from multiple table rows||24||49|
|SQL 2008 - Disappearing Temp Table in Stored Procedure||24||54|
|SQL Server Code Optimization when a single Proc gets called multiples times inside another Stored Proc||8||32|
|Modifying Powershell to list all server with SQL Server running ?||4||13|
Join the community of 500,000 technology professionals and ask your questions.