Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dividend
Starting Member
5 Posts |
 Posted - 2005-08-27 : 21:11:38
|
| Could someone tell me the datatypes for the SQL EXPRESS 2005I'm trying to use a boolean datatype and it says it isn't a datatype....have they changed it??? Please HELP!!!Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-27 : 22:07:35
|
| Boolean was never a valid datatype in any version of SQL Server, so they didn't change anything. The closest value that SQL Server supports is the bit dataype, which holds a 1 or 0. The CLR integration with SQL 2005 lets you create a user-defined CLR boolean type that you can use, but it's not a native SQL datatype. |
 |
|
|
Dividend
Starting Member
5 Posts |
Posted - 2005-08-27 : 22:50:00
|
| It was in SQL:1999!! |
|
|
|
Dividend
Starting Member
5 Posts |
Posted - 2005-08-27 : 22:52:13
|
| Hey thanks for the BIT that will work!! |
|
|
|
Dividend
Starting Member
5 Posts |
Posted - 2005-08-27 : 23:07:25
|
| I hate to ask but could you send me all the datatypes, and for types like date/time could you dend me the default for the current date/time??? I tried Now() but that don't seem to wanna work.. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-28 : 08:48:30
|
| Books Online is available here:http://www.microsoft.com/downloads/details.aspx?FamilyId=F0D182C1-C3AA-4CAC-B45C-BD15D9B072B7&displaylang=enSQL 1999 was an ANSI standard, and IIRC it was never finalized or published (from what I hear it was due to being a crap standard). SQL2003 is the latest ANSI SQL standard. Regardless, no database vendor or product has ever fully implemented an ANSI standard, especially since many features were added to each product long before they became part of the standard, and vendors did not see any need to change them. |
|
|
|
Dividend
Starting Member
5 Posts |
Posted - 2005-08-28 : 11:04:29
|
| Thanks robvolk!! |
|
|
|
|
|
|
Datatypes