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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Basics of SQL

Author  Topic 

rlong04
Starting Member

2 Posts

Posted - 2005-10-24 : 10:48:27
Hi, I am used to using Access but I need to learn SQL for larger web sites. I normally build the database in Access visually, but how do you do this with SQL? I just installed SQL developer and I can't find the area that builds the database.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-10-24 : 11:08:00
that would be enterprise manager.
for starters that will be enough. read a book about sql server. it can do you good.
http://www.sqlteam.com/store.asp

Go with the flow & have fun! Else fight the flow
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-10-24 : 14:46:19
"I can't find the area that builds the database"

Have a look, in Enterprise Manager, at "Table Designer" and also at making a "Diagram" from your database (once the "diagram" is created you can change the columns properties etc. from the diagram itself.

"...SQL developer..."

Is this SQL 2005? I don't have any knowledge of that, so it will have changed from my suggestions.

Kristen
Go to Top of Page

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-10-25 : 01:38:34
Hi,

download SQL Books ON Line tooo , it comes with all you wants to know about it with very good examples that will clear all your doubt and for books on sql i suggest to refer

[url]http://vyaskn.tripod.com/sqlbooks.htm[/url]


-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com
Go to Top of Page
   

- Advertisement -