Browsed by
Day: April 12, 2012

Validating email string without using sp_OACreate in T-SQL

Validating email string without using sp_OACreate in T-SQL

I wanted a way to validate that an email address in a SQL query was well-formed, and found a lot of resources suggesting to create a scalar function that invokes sp_OACreate among others, and return a bit indicating if it was valid or not.  That works great, but not for those of us in heightened security environments, where granting execute permissions to system stored procs and functions is not permitted.  After searching around I came up with the following function:…

Read More Read More