Visual Studio Magazine

10 More New T-SQL Functions

Building on the DATETIMEFROMPARTS, DATETIME2FROMPARTS offers similar functionality, but yields more precise DateTime2 data type, containing fractions of a second to a specified precision. Naturally, ...
EDN

Prometheus Research Unveils New HTSQL Functions Including Support for Django, Nested Queries, and Improved Export Features

“The latest release, HTSQL 2.3, is especially exciting for Python developers because it includes a HTSQL-Django gateway,” said co-creator Clark Evans, also of YAML fame. “Also, we completely rewrote ...
Ars Technica

Oracle 9i O-R SQL: Multiple nested tables

Hello all!<BR><BR>So I'm work on learning O-R sql, and I'm having trouble with creating a table that has more than one nested table. <BR><BR>My code and errors are as ...
Visual Studio Magazine

A CLR Alternative to the SQL Server ISNUMERIC function

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