DIFFERENCE BETWEEN NUMERIC AND DECIMAL DATA TYPE IN SQL SERVER 2005

Similarities & Differences.

1. Both are same . there is no difference.

2.Precision and storage space details are given below

Precision 1 – 9 , Storage space 5 Bytes
Precision 10 – 19 , Storage space 9 Bytes
Precision 20 – 28 , Storage space 13 Bytes
Precision 29 – 38 , Storage space 17 Bytes

Pawan Kumar
Pawankkmr@hotmail.com

Advertisements