Friday

sql today

to get today's records from table :

select * from mytable where
CONVERT(varchar(8), mydatefield, 112)=CONVERT(varchar(8), GETDATE(), 112)

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