rajeeva_nagaraj
asked on
SQL Select
Hi,
I was trying few queries on SQL server, i just gave the below query and i was baffled with the result it gave.
Query : Select '1' + 1
Result = 2
I was expecting the sql server to throw an error while i try to add varchar 1 ('1') and the integer 1 (1), instead it added both the numbers and returned the result as 2.
Can anyone guide me on my the select query added those 2 numbers and why it did not throw an error.
Thanks in advance,
Rajeeva
I was trying few queries on SQL server, i just gave the below query and i was baffled with the result it gave.
Query : Select '1' + 1
Result = 2
I was expecting the sql server to throw an error while i try to add varchar 1 ('1') and the integer 1 (1), instead it added both the numbers and returned the result as 2.
Can anyone guide me on my the select query added those 2 numbers and why it did not throw an error.
Thanks in advance,
Rajeeva
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.