I'm using Int
and Integer
datatypes in my stored procedures, both behaviors are looking same.
Is there any difference between them?
There is no difference between the 2. A quick look at the documentation shows that integer
is a data type synonym for int
. Note that while this link is for SQL Server 2000, the answer remains valid all the way till SQL Server 2014.
They are the same thing.
Source:http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
Duplicate:What is the difference between int and integer in MySQL 5.0?
EDIT: From shree.pat18, I'm being an idiot and I put MySQL documentation instead of SQL server since is was reading too fast.
Microsoft says they are the same thing as well. As shree.pat18 said, MySQL and SQL have similar documentation and to a lesser extend SQLite, cheers.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With