SQL Data Types...

[GDX]

I am looking for a complete article that explains all the data types in SQL2K i checked msdn but came up empty, i really need to find out whats nvarchar and what data type is the best way to save a users info like:

UserID
Password
Date (i will use the date/time data type)
Name
Email

and so on, Ive been using Nvarchar but I am not quite sure which is the best. THanks
Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[palbano]

Gordon,

Searched on msdn for "all words" ( SQL DATA TYPES) quickly pointed me to the (DATA SERVICES/SQL SERVER/TRANSACT-SQL REFERENCE) node in the MSDN library. In that tree node there is a page title DATA TYPES.

Here is a link to save you the trouble of finding it yourself.

http://msdn.microsoft.com/library/default.asp?ShowPane=false&URL=/library/psdk/sql/ts_da-db_7msw.htm

Also this is the Microsoft: Active Server Pages (ASP)Forum where this question is "off topic". Try the SQL forum next time on this site where LOTS of SQL people can help you, OK?

-pete

 

[GDX]

Thank you.

Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371