IM201: Хэрэг болох материалууд

1. Beginning SQL Server 2005 For Developers ном татах
2. Лекц татах
3. Материал 1 татах
4. Материал 2 татах
5. Материал 3 татах
6. MS SQL 2005 програм татах

CREATE DATABASE skul

ON PRIMARY 

( NAME = skul_dat, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\skuldat.mdf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),

( NAME = skul1_dat, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\skul1dt.ndf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),

LOG ON

( NAME = 'skul_log', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\skullog.ldf', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )

GO 

IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'degree') DROP TABLE degree;

Posted in: im201n