Author |
Topic |
ed123
Starting Member
6 Posts |
Posted - 2006-08-05 : 14:57:21
|
I installed Microsoft SQL Server 2005 Express. However, all that shows up in my "Start" menu is "Configuration tools." How do I open the application where I can start coding? |
|
nr
SQLTeam MVY
12543 Posts |
|
ed123
Starting Member
6 Posts |
Posted - 2006-08-05 : 16:36:22
|
Then how do I write an SQL code with Express? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-05 : 16:56:17
|
Look at the link.it's sql server management studio express.With msde you would use osql and could still use that.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
ed123
Starting Member
6 Posts |
Posted - 2006-08-05 : 17:13:50
|
Sorry nr, I'm a beginner with this. Can you please explain to me the difference between server management studio express and Server 2005 Express. Also, what are msde and osql? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-05 : 17:19:06
|
Msde is the v2000 equivalent of express.osql is a command line interface to sql server.Management studio is the the qui for v2005.Management studio express is the free equivalent for sql server express.sql server 2005 express is the (cut down) sql server database engine.Try using google and the microsoft site.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
ed123
Starting Member
6 Posts |
Posted - 2006-08-05 : 17:26:53
|
So basically I have to install both management studio express and server 2005 Express? Why wouldn't they put them both in one package? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-05 : 17:28:22
|
You maybe should ask why they give away management studio express - they never did for v2000.Or why don't they give away the full version.What about all the people who just want the database engine? Why force them to download the gui?No you don't need to install them both - only if you want them both.It's free - be grateful for what you get.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
ed123
Starting Member
6 Posts |
Posted - 2006-08-05 : 18:26:27
|
what's the difference between express and the one you have to pay for? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-05 : 18:42:19
|
How did you find out about expressseehttp://www.microsoft.com/sql/prodinfo/overview/default.mspxTry using google.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
ed123
Starting Member
6 Posts |
Posted - 2006-08-05 : 19:01:08
|
OK Thanks nr. You've been very helpful. |
|
|
|