October 24, 2002 at 12:17 pm
I am new to SQL Server. I'm comfortable with ASP and Access, but I have some contract work that requires a SQL database. Is there a reference (book or online) that will help me learn to create a SQL database?
Also, is SQL Server command-line driven?
Thank you in advance for your help!
Livvy
October 24, 2002 at 6:48 pm
Tons of books, try half.com to pick up something cheap even if only for SQL7. Creating db's is about the same in SQL2K. Online you can hit http://www.msdn.microsoft.com or http://www.microsoft.com/sql for lots of information about SQL. SQL runs as a service, you can interact with it using Enterprise Manager which is a GUI, or Query Analyzer which allows you to send commands (queries, DDL) to the server and get results back, OSQL has no UI, pure command line. Most app level data access done via a library, right now that is ADO, DAO, maybe ADO.Net.
I'd recommend downloading the eval copy of SQL and just giving it a try. We'll be glad to answer questions once you get started.
Andy
October 24, 2002 at 6:52 pm
Also try books on line from SQL Server. To get help from the create database sentence search it in Books on line or Open Query analizer and type Create database, selected and press F1 to get help related to that command.
October 25, 2002 at 7:12 am
I 'stole' this link from Steve Jone's article 'Conflicting Instructions' (go to the home page and check it out). This is the link to get the download for the updated SQL 2000 Books Online.
- http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
-Bill
October 25, 2002 at 9:50 am
<shamelessplug> Brian's Admin 911 book is a good beginner place to learn about admin'ing SQL Server.
</shamelessplug>
For designing tables, it works similar to Access, though I'd grab any of the "application" books for SQL Server to get some hints. All repeat 60% of the same info. Pick one that's easy to read for you.
Also, set an "sa" password and don't use "sa" in your application.
Steve Jones
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply