-
creating data base with microsoft SQL 7.0
HI, I am new to sql an just bought a boo.I am trying to create a date base
with a simple table.My problem is that I don't know what procedures should
I follow in order to create using Microsoft SQL server 7.0 .Can someone help
me with this,this will be my very first sql database. Any help will be greatly
apreciated.
thanks
-
Re: creating data base with microsoft SQL 7.0
Here's a simple T-SQL script for building a database that you can run in Query
Analyzer or in code. Be careful about accidently building a database on
any drive (such as c that has limited space.
CREATE DATABASE B936_DB
ON
PRIMARY ( NAME = B936_DB_Dat,
FILENAME = 'd:\data\B936_DB.mdf',
SIZE = 1MB,
FILEGROWTH = 10MB)
LOG ON
(NAME = B936_DB_Log,
FILENAME = 'd:\data\B936_DB.ldf',
SIZE = 1MB,
FILEGROWTH = 5MB)
GO
"jose" <joseamarte@netzero.net> wrote:
>
>HI, I am new to sql an just bought a boo.I am trying to create a date base
>with a simple table.My problem is that I don't know what procedures should
>I follow in order to create using Microsoft SQL server 7.0 .Can someone
help
>me with this,this will be my very first sql database. Any help will be greatly
>apreciated.
>
>thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|