| Author |
Topic |
|
tennis_girl
Starting Member
40 Posts |
 Posted - 2008-10-27 : 19:30:16
|
| Hi all,I'm really new to SQL. can someone please tell me what program to use to test SQL commands on windows?I simply want to create tables and insert values and create views, etc.Thanks for your quick answer. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-27 : 19:39:38
|
| In management studio, use query editor. |
 |
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 05:46:38
|
quote:
Originally posted by afrika
In management studio, use query editor.
thanks afrika :)so the best solution is to use management studio?does it come with query editor? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-28 : 05:48:16
|
| yup. you've query editor available in sql managment stdio. You can use other thrid party client tools like TOAD |
|
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 05:53:41
|
| I am really new to this!it all sounds kind of complicated. I don't know what a third party client is?! :( |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-28 : 05:56:54
|
quote:
Originally posted by tennis_girl
I am really new to this!it all sounds kind of complicated. I don't know what a third party client is?! :(
i was just giving you an alternative. if you've sql managment studio you dont need anything else. |
|
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 05:58:40
|
| can I get the Microsoft SQL Server Management Studio Express?or does it have to be the full version? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-28 : 06:01:25
|
quote:
Originally posted by tennis_girl
can I get the Microsoft SQL Server Management Studio Express?or does it have to be the full version?
yup. Express is fine. You can download it freely from net. see link belowhttp://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en |
|
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 06:04:00
|
| thanks visakh16 :)I'm downloading now, do I need to get its server pack1 too? you think? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-28 : 06:16:39
|
quote:
Originally posted by tennis_girl
thanks visakh16 :)I'm downloading now, do I need to get its server pack1 too? you think?
yup...better to get all prerequisites they've asked for in sites. Also if you've plans to use export-import wizard, then you need to download express toolkit as well.http://mobiledeveloper.wordpress.com/2007/01/31/data-import-export-with-sql-server-express-using-dts-wizard/ |
|
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 06:22:31
|
| we haven't done any import/export yet.. I don't think we need that for now. ok got the service pack too. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-28 : 06:25:09
|
quote:
Originally posted by tennis_girl
we haven't done any import/export yet.. I don't think we need that for now. ok got the service pack too.
then its fine...cheers  |
|
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 06:27:21
|
| in the future selection should i get " client components "?remember that I want to practice creating tables, editing them, creating views and stuff..do i need that? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-28 : 06:29:46
|
| yup...you need to select clinet components. i belive you have an existing sql server where you'll be connecting to and creating tables,... |
|
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 06:32:17
|
| wow there is a service pack 2 as well!!! this never finishes! |
|
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 06:33:24
|
| visakh16, the only sql server I will be having is the one I'm downloading, what do you mean by exisiting sql server? |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 06:39:39
|
| lolwell I guess I better get 2005 then :) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-28 : 06:48:18
|
quote:
Originally posted by tennis_girl
visakh16, the only sql server I will be having is the one I'm downloading, what do you mean by exisiting sql server?
i thought you just wanted the client components alone to connect to a db. If you have a server then you need to install the database engine feature also. |
|
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 06:51:42
|
| I meant to say I'd like to have 2008 :)I'm an absolute newbee so I have nothing on my computer.I downloaded what you guys said.I'm kinda lost! :( |
|
|
|
tennis_girl
Starting Member
40 Posts |
Posted - 2008-10-28 : 06:55:47
|
| I simply want to be able to create tables and views and search through data and things like that.Can you tell me what I need to download??At school we work with postgresql and linux. But I have windows vista on my computer. I just want to be able to practice the commands we are leaning at school on my own laptop. Drop table, inster into films, etc. |
|
|
|
Next Page
|
testing commands