Article ID: 169072
Article Last Modified on 10/16/2003
CREATE TABLE floatTable
(
GuessWhatCol double precision,
charCol char
)
GO
SP_HELP floatTable
GO
CREATE TABLE realTable
(
charCol char,
GuessWhatCol double precision
)
GO
SP_HELP realTable
GO
The GuessWhatCol in floatTable becomes float, which is 8 bytes in size,
while the same GuessWhatCol in realTable is real, and 4 bytes in length.
/* Using binary precision in SQL Server 6.50 */
CREATE TABLE floatTable
(
GuessWhatCol double precision(25), /* float datatype */
charCol char
)
GO
SP_HELP floatTable
GO
CREATE TABLE realTable
(
charCol char,
GuessWhatCol double precision(24) /* real datatype */
)
GO
SP_HELP realTable
GO
/* Using decimal precision in SQL Server 6.0 */
CREATE TABLE floatTable
(
GuessWhatCol double precision(8), /* float datatype */
charCol char
)
GO
SP_HELP floatTable
GO
CREATE TABLE realTable
(
charCol char,
GuessWhatCol double precision(7) /* real datatype */
)
GO
SP_HELP realTable
GO
Keywords: kbbug kbusage KB169072