Tuesday

sql select comma delimited field as one row


SELECT TOP 10
hphone + ', ' as [text()]
from
person
for
xml path('')

No comments:

test smtp server with powershell

Send-MailMessage -SMTPServer smtp.domain.com -To [email protected] -From [email protected] -Subject "This is a test email" -Body ...