Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the difference between Int and Integer datatypes in SQL Server?

Tags:

sql-server

I'm using Int and Integer datatypes in my stored procedures, both behaviors are looking same.

Is there any difference between them?

like image 478
DSK Avatar asked Jul 30 '14 12:07

DSK


2 Answers

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.

like image 71
shree.pat18 Avatar answered Oct 23 '22 00:10

shree.pat18


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.

like image 2
bhuvy Avatar answered Oct 22 '22 23:10

bhuvy