Posts Tagged ‘SQL’

Date issue with ColdFusion and SQL Server Stored Procedure

I had an unexpected issue today with a SQL Server stored procedure that worked fine in SQL Server Management Studio (SSMS), but threw the following error when I ran it in ColdFusion: [Macromedia][SQLServer JDBC Driver][SQLServer]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value This was odd as the […]

Unique constraint vs NULL values in SQL Server

Lately, I’ve been working with a SQL Server database table that contains people. Each person has a system-generated ID as their primary identifier in the system, but we also hold a national identifier (something like a National Insurance or Social Security Number) in a second column. Today, I’ve been changing the application to allow the […]