adspace


What is the difference between numeric and autonumber?

Answer Posted / Firoz Dost

In SQL, NUMERIC is a data type used for exact numerical values with decimal points, while AUTOINCREMENT (also known as IDENTITY in some databases) is a property that automatically assigns unique numerical values to new records.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current version of postgresql?

1188


what is sql server agent? : Sql dba

1189


If a cursor is open, how can we find in a pl/sql block?

1252


Can we rollback truncate?

1083


Does group by remove duplicates?

1121


Do we need to rebuild index after truncate?

1155


What is the best sql course?

1064


how to use regular expression in pattern match conditions? : Sql dba

1125


How do I remove duplicates in two columns?

1202


define sql insert statement ? : Sql dba

1110


Is primary key always clustered index?

1101


what are aggregate and scalar functions? : Sql dba

1142


What is the current version of sql?

1106


What is your daily office routine?

2353


what are all the common sql function? : Sql dba

1142