SQL Serve基础查询练习(附答案).docVIP

--创建数据库 USE [master] GO CREATE DATABASE [test] ON PRIMARY ( NAME = Ntest, FILENAME = ND:\SQL \DataBase\test.mdf , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = Ntest_log, FILENAME = ND:\SQL \DataBase\test_log.ldf , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO ALTER DATABASE [test] SET COMPATIBILITY_LEVEL = 90 GO IF (1 = FULLTEXTSERVICEPROPERTY(IsFullTextInstalled)) begin EXEC [test].[dbo].[sp_fulltext_database] @action = enable end GO ALTER DATABASE [test] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [test] SET ANSI_NULLS OFF GO ALTER DA