MS-SQL Server - Managing
your SQL Databases
- There are three ways to build
and manage tables within MS-SQL7.
A) Execute individual SQL commands from within your pages.
B) Build the database in Access 2000, and then upsize into SQL
Server.
C) Connect to the SQL Server using SQL Server Enterprise
Manager.
Generally, you will want to upsize from Access or work
directly with the DB using Enterprise Manager. If you want to
execute custom SQL statements for building and managing tables
from within your page, you should head to the book store and
buy some books about SQL syntax. Custom crafting statements to
create tables is not hard to do, but it is the least
user-friendly way of building the tables. Most LaMarSOFT
customers will choose to upsize from an existing Access 2000
database or to connect to the SQL Server using SQL Server
Enterprise Manager.
- Upsizing from Access 2000
- SQL Server Enterprise Manager
- FAQs
- Privacy Policy
|
© 1996, 1997,1998,1999, 2000,
2001 LaMarSOFT.com. All rights reserved. All other trademarks are
the sole property of their respective owners. We only recommend
products that we have personally tried or use regularly. Performance
of any product or service is the sole responsibility of its
creator/owner. We assume no responsibility for advice, tips,
scripts, or programs provided here since we have no control over
their ultimate use or implementation. As always -- make a backup
first! Your privacy is important to us. Please read our Privacy
Statement for details. We may be contacted at webmaster@lamarsoft.com.
Last Updated:
Sunday February 10, 2002
|
|
|
