SQL floating point compare function

  •        0

Comparison of floating point values in SQL Server not always gives the expected result. With this function, comparison is only done on the first 15 significant digits. Since SQL Server only garantees a precision of 15 digits for float datatypes, this is expected to be se...

http://floatequalsfloat.codeplex.com/

Tags
Implementation
License
Platform

   

comments powered by Disqus


Related Projects

SQL Workbench - DBMS-independent SQL query tool


SQL Workbench is a DBMS-independent, cross-platform SQL query tool. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. It could compare the data of two database and generate the necessary SQL statements to migrate one to the other.

MySQL Workbench - Visual database design tool for MySQL


MySQL Workbench is a visual database design tool. The tool is specifically for designing MySQL database. MySQL Workbench provides DBAs and developers an integrated tools for Database Design & Modeling, Query browser, Database Administration.

Carrot2 - Search Results Clustering Engine


Carrot2 is an Open Source Search Results Clustering Engine. It could cluster the search results from various sources and generates small collection of documents. Carrot2 offers ready-to-use components for fetching search results from various sources including YahooAPI, GoogleAPI, Bing API, eTools Meta Search, Lucene, SOLR, Google Desktop and more.

PostGIS - Spatial and Geographic objects for PostgreSQL


PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. PostGIS adds extra types (geometry, geography, raster and others) to the PostgreSQL database. It also adds functions, operators, and index enhancements that apply to these spatial types.

Open Web Analytics - Analytics used by Wikimedia


Open Web Analytics is open source web analytics software that you can use to track and analyze how people use your web sites and applications. OWA provides web site owners and developers with easy ways to add web analytics to their sites using simple Javascript, PHP, or REST based APIs. OWA also comes with built-in support for tracking web sites made with popular content management frameworks such as WordPress and MediaWiki.

kokpit-db


Kokpit-db is an integrated monitoring, comparison and performance analysis software for Oracle databases. It can compare and monitor versions 8i, 9i, 10g and 11g. Supports standby databases and ASM instances. GUI and command line interfaces available

Adminer - Database Management in Single PHP file


Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch and MongoDB

MySQL


The MySQL database is the world's most popular open source database.

Doctrine ORM - Object relational mapper for PHP


Object relational mapper (ORM) for PHP that sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL. This provides developers with a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication.

Sphinix


Sphinix is free open-source SQL full-text search engine. How do you implement full-text search for that 10+ million row table, keep up with the load, and stay relevant? Sphinx is good at those kinds of riddles.