creating data base with microsoft SQL 7.0


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: creating data base with microsoft SQL 7.0

  1. #1
    jose Guest

    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

  2. #2
    CLM Guest

    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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center