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.
EXEC master..xp_cmdshell 'sqlcmd -S pmdb01 -d Ntier_Training -Q "SELECT * FROM dbo.Birthdate" -o "C:\output1.csv"'
DECLARE @MonthNumber int SET @MonthNumber = 12 SELECT Prim_Policy_Certificate_No, Patient_Name, Patient_Street1, Patient_Street2, Patient_City, Patient_State, Patient_Zip_Code, Prim_Policy_Carrier_Name, Patient_DOB FROM PM.vwGenPatInfo WHERE MONTH(Patient_DOB) = @MonthNumber