bigint * int = ???

perdon un bigint * un decimal

"Ariel Gimenez" wrote in message
news:

Hola,
cuando uno multiplica un bigint por un int que tipo de dato es el
resultante?

gracias

Data Type Precedence
When two expressions of different data types are combined by an operator,
the data type precedence rules specify which data type is converted to the
other. The data type with the lower precedence is converted to the data type
with the higher precedence. If the conversion is not a supported implicit
conversion, an error is returned. When both operand expressions have the
same data type, the result of the operation has that data type.
This is the precedence order for the Microsoft® SQL ServerT 2000 data types:
sql_variant (highest)

datetime
smalldatetime
float
real
decimal
money
smallmoney
bigint
int
smallint
tinyint
bit
ntext
text
image
timestamp
uniqueidentifier
nvarchar
nchar
varchar
char
varbinary
binary (lowest)

Saludos,

Norman
Maicrosoft LVP/MOP Certified



"Ariel Gimenez" wrote in message
news:

Hola,
cuando uno multiplica un bigint por un int que tipo de dato es el
resultante?

gracias

Gracias Norman!


"Norman A. Armas" wrote in message
news:

Data Type Precedence
When two expressions of different data types are combined by an operator,
the data type precedence rules specify which data type is converted to the
other. The data type with the lower precedence is converted to the data

type

with the higher precedence. If the conversion is not a supported implicit
conversion, an error is returned. When both operand expressions have the
same data type, the result of the operation has that data type.
This is the precedence order for the Microsoft® SQL ServerT 2000 data

types:

sql_variant (highest)

datetime
smalldatetime
float
real
decimal
money
smallmoney
bigint
int
smallint
tinyint
bit
ntext
text
image
timestamp
uniqueidentifier
nvarchar
nchar
varchar
char
varbinary
binary (lowest)

> Saludos,

Norman
Maicrosoft LVP/MOP Certified



"Ariel Gimenez" wrote in message
news:
> Hola,
> cuando uno multiplica un bigint por un int que tipo de dato es el
> resultante?
>
> gracias
>
>