Basic Datatypes in SQL Server?

Question

What should i know about involving basic data types in SQL Server?

In my database i need

1. Flags/bits, I assume I should use byte
2. 64bit ids/ints
3. a variable length string. It could be 5 letters it could be 10,000 (for desc but i plan to allow unlimited length usernames)

Is there a TEXT type in SQL Server? I dont want to use varchar(limit) unless i could use something ridiculously high like 128k. How do i specify 1byte - 8byte ints?

Answer 1

Others have already provided good answers to your question. If you are doing any .NET development, and need to map SQL data types to CLR data types, the following link will be quite useful.

http://msdn.microsoft.com/en-us/library/bb386947.aspx

Randy

Answer 2

For 1), use BIT - it's one bit, e.g. eight of those fields will be stuck into a single byte.

For 2), use BIGINT - 64-bit signed int

For 3), definitely do NOT use TEXT/NTEXT - those are deprecated as of SQL Server 2005 and up.

Use VARCHAR(MAX) or NVARCHAR(MAX) for up to 2 GB of textual information instead.

Here's the list of the SQL Server 2008 data types:

http://msdn.microsoft.com/en-us/library/ms187594.aspx

Answer 3

• Flags/bits, I assume I should use byte

Use "bit" which is exactly that: one bit

• 64bit ids/ints

bigint is 64 bit signed

• a variable length string. It could be 5 letters it could be 10,000 (for desc but i plan to allow unlimited length usernames)

varchar(max) is up to 2GB. Otherwise varchar(8000) is the conventional limit

Microsoft even put into a nice handy web page for you

Answer 4

Here is the document.

http://msdn.microsoft.com/en-us/library/aa258271%28SQL.80%29.aspx