new to ms sql server 2005

[hitechs71]

I have a sql server 2003 in which ms sql server 2005 is install. when i press start button i see Microsoft Server 2005 tab and under that tab is six more tab which are 1.analysis services, 2.configuration tools, 3.documention and tools, 4.performance tools, 5.sql server business intelligence, 6.sql server managment studio.

My question i want to create new database with table and its field how do i do it. Any help here

 

[bborissov]

Run
6.sql server managment studio
it combines both tools from SQL 2000: Enterprise Manager and Query Analizer

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[hitechs71]

i ran option 6 and it asked my user and pass which i did then i got a big windows. on the left side i have
- server name
+ Databases
+ Security
+ Server Objects
+ Replication
+ Management
+ Notification Services
- SQL Server Agent (Agent XPs Disabled)

what should i do. to create a database and in that i want to create table with fields

Thanks for the help

 

[bborissov]

Right Click on DataBases, and select New DataBase. Follow the wizzard. When you create your database, expand DataBases node, if your DataBase is not there right click on DataBases node and choose Refresh.
When you DataBase appears Expand its nodes and right click on Tables. Select New table.


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[hitechs71]

Thank you for you direction. I am doing good.
I did as you told me when i created the database and expand that database node i see Database diagram, tables, views, synonyms, programmability, service broker, storage, security. i understand about the table but does other stuff means.

I right click tables and clicked new table now i allow me to create column for that table which is Table_1. How can i name these that i want.

 

[hitechs71]

When i am trying to create new field in column name i see [name] (boxes around name) and some time i see just name (nothing) what does that mean

 

[hitechs71]

Cheers i could save table and name it. That great. Now how do i write simple insert and select query.
Thanks

 

[bborissov]

hitechs71,
I see you are new not only to SQL Server 2005 but to SQL Server at all
I don't want to be rough, press F1.
That will invoke Books On Line (often called BOL) and read all you need.

How to use SQL Server, how to manage data and create everything for that data, Database design, working with SSMS (SQL Server Management Studio) is a huge article that can't be covered in forum.
Read BOL, search for SQL books that match your needs (unfortunately I can't give you some list right now).

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[hitechs71]

Thanks you very for the help. You know how to write query and and that stuff. I have done it with Postgresql so i know that part as i am a programmer. but never had hands on ms sql server. Person like you who can at least show us the direction can be really help. I really appreciate for your time.
Thanks

 

[bborissov]

If you now how to write queries, you know almost everything Than you only need to learn how to work with SSMS. Try everything, clik, right-click everywhere. What could happen? In the worst case - reinstall SQL Server

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP