June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Difference and Explanation among DECIMAL, FLOAT and NUMERIC

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Datatype, SQL Scripts
The basic difference between Decimal and Numeric : They are the exactly same. Same thing different name. The basic difference between Decimal/Numeric and Float : Float is Approximate-number data type, which means that not all values in the data type range can be represented exactly. Decimal/Numeric is Fixed-Precision data type,…
Read More

SQL SERVER – 2005 – Use of Non-deterministic Function in UDF – Find Day Difference Between Any Date and Today

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DateTime, SQL Error Messages, SQL Function, SQL Scripts
While writing few articles about SQL Server DataTime I accidentally wrote User Defined Function (UDF), which I would have not wrote usually. Once I wrote this function, I did not find it very interesting and decided to discard it. However, I suddenly noticed use of Non-Deterministic function in the UDF.…
Read More

SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Backup and Restore, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Function, SQL Index, SQL Scripts, SQL Stored Procedure, SQL Trigger
Update: This article is re-written with SQL Server 2008 R2 instance over here: SQL SERVER – 2008 – 2008 R2 – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects Following quick tutorial demonstrates…
Read More