| Author |
Crating a database
|
|
| cocolocopolo 2002-04-11, 2:36 am |
| Just begain studying SQL Server 2000 the other day with Sam's 21 days. It comes to the point to create a new database. It says that there are three methods to create a new database.
1. The Database Creation Wizard
2. The SQL Server Enterprise Manager
3. The CREATE DATABASE statement
I only can find "The SQL Server Enterprise Manager" to create new database, but I really cannot find out where is the Database Creation Wizard and Create DATABASE statement to create new database.
Would appreciate any body give me some idea, where is the Database Creation
Wizard and the CREATE DATABASE statement???
Many thanks in advance. | |
| anthonie 2002-04-11, 4:04 am |
| Database Creation Wizard:
1. Start SQL Server Manager.
2. Click your server.
3. Click Tools, Wizards.
4. Expand Database, double click Create Database Wizard.
Enterprise Manager:
1. Expand your server.
2. Right click Databases, click New Database.
Create Database Statement:
1. Start Query Analyzer.
2. Log on to your server.
3. Type in the SQL script.
4. Run the script. | |
| cocolocopolo 2002-04-11, 4:11 pm |
| Dear anthonie
Thanks for your instruction.
I did not expand no wonder I cannot find the
correct wizard.
For the query, wonder if the statement syntax is "case sensitive" or "cas insensitive"???
Thanks again. | |
|
| quote:
Originally posted by cocolocopolo
For the query, wonder if the statement syntax is "case sensitive" or "cas insensitive"???
It's like most SQL - it's case insensitive, but any identifiers you use when creating objects will be stored in the case you specify.
The following two statements:
create proc getstuff as [....]
create proc GetStuff as [....]
are equivalent. Both can be called as
exec getstuff
exec GetStuff
exec GETSTUFF
etc.
It's just a matter of what looks better. I'd go for GetStuff since I find it easier to read, but your taste and naming convention might differ.
Check out the SQL Server books online for more info. | |
| cocolocopolo 2002-04-11, 6:36 pm |
| Thanks J-Ho
I feel much better now to see this is case "insensitive". |
|
|
|