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 |
|
B5CSE
Starting Member
25 Posts |
 Posted - 2005-03-31 : 03:30:32
|
| what the difference between Query analyzer and enterprise manager I mean what advantages and disadvantages when create tabels usingboth Query analyzer and enterprise manager |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-03-31 : 08:05:14
|
| If you create a table using query in QA, it is somewhat faster as no need to select the resuired datatype from drop down.MadhivananFailing to plan is Planning to fail |
 |
|
|
B5CSE
Starting Member
25 Posts |
Posted - 2005-03-31 : 12:21:07
|
| please I want more clear illustration |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-31 : 13:30:50
|
Why don't you just do it once each way so that you can see the differences for yourself?quote:
Originally posted by B5CSE
please I want more clear illustration
CODO ERGO SUM |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-03-31 : 14:02:46
|
| EM has a decent user interface for setting up tables if you are more comfortable doing it visually; query analyzer does not have a UI you must use CREATE TABLE commmands.As MVJ says, why don't you try it yourself? Or is this an interview question or a quiz or something.- Jeff |
|
|
|
SqlShaun
Starting Member
14 Posts |
Posted - 2005-04-01 : 08:26:23
|
| You should use both. Query Analyser is for writing queries, and Enterprise Manager is for everything else. Use Enterprise Manager for creating tables if you are feeling lazy otherwise use Query Analyser. Enterprise Manager is more UI Oriented. ;-) thats my theory. |
|
|
|
|
|
|
please help me