Casting question

Question

Viewing 4 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply

baabhu SSCertifiable Points: 6205 More actions · Answer 1

Neither I don't understand for the reason for char(3).

sqlnaive SSCoach Points: 17437 More actions · Answer 2

Seems pretty simple question to me. An easy point.

Arno Kwetters Hall of Fame Points: 3876 More actions · Answer 3

Why is the type char(3) ?

If I use one of the below selects, then it is all the same !

select convert (char(3),11/9)

select convert (int,11/9)

select convert(float ,11/9)

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 4

good question on datatype conversion practices.

Thanks.

Cookies on SQLServerCentral