精品资料（2025-2025收藏）SQL Server基础查询练习VIP专享

--创建数据库USE [master]GOCREATE DATABASE [test] ON PRIMARY ( NAME = N'test', FILENAME = N'D:\SQL \DataBase\test.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'test_log', FILENAME = N'D:\SQL \DataBase\test_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)GOALTER DATABASE [test] SET COMPATIBILITY_LEVEL = 90GOIF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))beginEXEC [test].[dbo].[sp_fulltext_database] @action = 'enable'endGOALTER DATABASE [test] SET ANSI_NULL_DEFAULT OFF GOALTER DATABASE [test] SET ANSI_NULLS OFF GOALTER DATABASE [test] SET ANSI_PADDING OFF GOALTER DATABASE [test] SET ANSI_WARNINGS OFF GOALTER DATABASE [test] SET ARITHABORT OFF GOALTER DATABASE [test] SET AUTO_CLOSE OFF GOALTER DATABASE [test] SET AUTO_CREATE_STATISTICS ON GOALTER DATABASE [test] SET AUTO_SHRINK OFF GOALTER DATABASE [test] SET AUTO_UPDATE_STATISTICS ON GOALTER DATABASE [test] SET CURSOR_CLOSE_ON_COMMIT OFF GOALTER DATABASE [test] SET CURSOR_DEFAULT GLOBAL GOALTER DATABASE [test] SET CONCAT_NULL_YIELDS_NULL OFF GOALTER DATABASE [test] SET NUMERIC_ROUNDABORT OFF GOALTER DATABASE [test] SET QUOTED_IDENTIFIER OFF GOALTER DATABASE [test] SET RECURSIVE_TRIGGERS OFF GOALTER DATABASE [test] SET DISABLE_BROKER GOALTER DATABASE [test] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GOALTER DATABASE [test] SET DATE_CORRELATION_OPTIMIZATION OFF GOALTER DATABASE [test] SET TRUSTWORTHY OFF GOALTER DATABASE [test] SET ALLOW_SNAPSHOT_ISOLATION OFF GOALTER DATABASE [test] SET PARAMETERIZATION SIMPLE GOALTER DATABASE [test] SET READ_COMMITTED_SNAPSHOT OFF GOALTER DATABASE [test] SET READ_WRITE GOALTER DATABASE [test] SET RECOVERY SIMPLE GOALTER DATABASE [test] SET MULTI_USER GOALTER DATABASE [test] SET PAGE_VERIFY CHECKSUM GOALTER DATABASE [t...