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

Ok. I have some tables that store dollar amounts, among other data. I had the fields set to be a data type of money, and was planning on the values including zero. When selecting the data, I was ...

Function inlining in SQL Server 2019 Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined. This means they will be folded into the query and no longer incur the UDF ...

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