i can't manage to make a db with my sql server?

Answer 1

if you choose query analyzer, the basic syntax is the fallowing:
create database NAMEOFDB
(after that you have to choose your new db in the drop down list if you want to create tables)
the syntax for creating tables is following:

create table NAMEOFTHETABLE
(NAMEOFTHECOLUMN TypeOFDate for example char (15) IfItIsPRIMARYKEY have to put following:primary key,
NAMEofTHEcolumn char (60) Not Null,
NAMEofTHECOLUMN int IfIT'sFOREIGNKEY you can do something like this: foreign key references NAMEOFTHETABLEWHEREIT'S PRIMARYKEY Not Null)

SO IT CAN LOOK SOMETHING LIKE THIS:

create table TOWN
(Zip int primary key,
Town char (60) )

create table Firm
(Code_Fir char (15) primary key,
Name_Fir char (60) Not Null,
Zip int foreign key references Town Not Null)


so on...

if you want to insert date (and don't have much just a few lines) use the following:

insert Town
values (11000, 'Beograd')
insert Town
values (21000, 'Novi Sad')
insert Town
values (24000, 'Subotica')
insert Town
values (18000, 'Nis')
--> meaning you have to put concrete value for each field in your table and separate it with comma


insert Firm
values (1, 'Apple', '11000')
insert Firm
values (8, 'Microsoft', '21000')
insert Firm
values (17, 'Si&Si', '24000')
insert Firm
values (50, 'Fly', '11000')
insert Firm
values (87, 'ME', '18000')

Answer 2

do not worry.
install SQL server 2000 .
then open Enterprise Manager from Start menu >> All Programs >>Microsoft SQL Server.

on the left side of opened window follow this path :
Console Root >>Microsoft SQL Servers>>SQL Server Group >>(local)
right click on Databases and choose new Dataase.
give the name and go ahead.

you will see the new database in right side .

Answer 3

i might want to signify replacing from residing abode abode windows authentication, and utilizing sq. authentication. I quite have lower than no circumstances considered actual all of us effectively make the significant of the residing abode abode windows authentication, and it consistently looks to create subject matters. to take action, you'll might want to set up someone account on the sq. Server, and ascertain you employ the similar human being call and password for it, and the the relationship. strong fulfillment, and please enable me understand if that doesn't artwork - i'm emailable through YA. strong fulfillment : )

Answer 4

Use enterprise manager to create a database.