Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...
I'm working on a project building a web site that helps craftsmen (bicycle framebuilders) manage their operations. Most bicycle framebuilders give their frames a serial number, which can be anything ...
<Microsoft.SqlServer.Server.SqlFunction()> Public Shared Function fnIsNumeric(field As SqlString, sqltype As String) As SqlBoolean Dim result As New SqlBoolean(0) 'default to False Dim errorMessage As ...