CompTIA
Exam Vouchers
Save money on CompTIA exams
| Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
| TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more | * ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i Online practice tests
Certification sites Online university Online college Online education Distance learning Software forum Server administration forum Programming resources
|
|  |
| Author |
Crating a database
|
cocolocopolo
Senior Member
Registered: Apr 2001
Location: Los Angeles
Country: USA
State:
Certifications: A+, Network+, CCNA
Working on: MCDBA
Total Posts: 287
|
|
 Crating a database
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.
__________________
cocolocopolo
Report this post to a moderator
|
|
 04-11-02 07:36 AM
|
|
anthonie
You may call me Semut
M
Registered: Sep 2001
Location:
Country: Malaysia
State:
Certifications:
Working on:
Total Posts: 525
|
|
|
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.
Report this post to a moderator
|
|
|
04-11-02 09:04 AM
|
|
cocolocopolo
Senior Member
Registered: Apr 2001
Location: Los Angeles
Country: USA
State:
Certifications: A+, Network+, CCNA
Working on: MCDBA
Total Posts: 287
|
|
|
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.
__________________
cocolocopolo
Report this post to a moderator
|
|
|
04-11-02 09:11 PM
|
|
J-Ho
Member
Registered: Mar 2002
Location:
Country: Ireland
State:
Certifications: MCDBA, MCSD, MCSA, MCSE
Working on: MCAD
Total Posts: 85
|
|
|
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.
Report this post to a moderator
|
|
|
04-11-02 09:24 PM
|
|
cocolocopolo
Senior Member
Registered: Apr 2001
Location: Los Angeles
Country: USA
State:
Certifications: A+, Network+, CCNA
Working on: MCDBA
Total Posts: 287
|
|
|
|
04-11-02 11:36 PM
|
|
|
MCSE exam notes
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is ON. |
|
ExamNotes forum archive
|
