11/19/2010
Зулаа
- Beginning SQL Server 2005 For Developers ном татах
- Лекц татах
- Материал 1 татах
- Материал 2 татах
- Материал 3 татах
- 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;
