Tuesday

sql split string


DECLARE @t VARCHAR(50)
SET @t = '3333-4'
SELECT LEFT(@t, CHARINDEX('-', @t) - 1), RIGHT(@t, LEN(@t) - CHARINDEX('-', @t))

more...

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 ...