Interview Question
Qus: What is data type for int, string, varchar?
Bigint – 8 bytes
Int – 4 bytes
smallInt- 2 bytes
TinyInt – 1 bytes
int data type in sql server stores 32 bit integer values.
string data type in sql server has various forms - char, varchar, text.
varchar data type in sql server can store maximum of 2^31-3 characters.
Answers (2)
Int – 4 bytes
smallInt- 2 bytes
TinyInt – 1 bytes
string data type in sql server has various forms - char, varchar, text.
varchar data type in sql server can store maximum of 2^31-3 characters.