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 |
|
jokxx
Starting Member
17 Posts |
 Posted - 2007-10-07 : 05:56:16
|
| i need a recommendation for a good database creator & manager software, with a simple user interface (not access :-) ). thx |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-10-07 : 10:28:25
|
Microsoft SQL Server 2005 is a good one.
Future guru in the making. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-10-07 : 10:29:19
|
have you tried the one that comes with SQL Server? it's called SQL Server Management Studio (SSMS).
elsasoft.org |
|
|
|
jokxx
Starting Member
17 Posts |
Posted - 2007-10-07 : 14:16:57
|
| thx, small question : what is the datatype i need so it would be an auto integer column , in SSMS? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-07 : 14:22:14
|
| datatype and auto integer are two separate things.You can have an INT datatype, with an IDENTITY property.Or you could have a BIGINT, for example, with the IDENTITY property.Kristen |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-10-07 : 15:57:30
|
an identity column must be:"int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, and constrained to be nonnullable"sadly you can't make a bit identity column. that would be neat. 
elsasoft.org |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-07 : 20:48:06
|
| In fact, you can find all those in sql books online. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-08 : 01:16:55
|
"sadly you can't make a bit identity column. that would be neat"Please don't encourage MS down that route ... we'll wind up with BigBit and Bit2 datatypes ...  |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-10-08 : 09:29:15
|
well, I don't see how I can globalize my app without at least a NBIT data type. Hopefully that's coming in Katmai.I've had to store them as text, with a different table for each language:"das stimmt""gar nicht wahr!"
elsasoft.org |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-08 : 09:43:21
|
"NBIT"Love it!  |
|
|
|
|
|
|
|
|
software recommendation