CODEWITHSUNDEEP
sql-server
DSK
DSK

Reputation: 101

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

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

Is there any difference between them?

Upvotes: 10

Views: 17822

Answers (2)

bhuvy
bhuvy

Reputation: 304

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.

Upvotes: 2

shree.pat18
shree.pat18

Reputation: 21757

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.

Upvotes: 16

Related Questions