一、CREATE DATABASE CREATE DATABASE命令用于创建一个数据库,创建一个数据库的最基本语法如下所示: CREATE DATABASE <database name> 1. CREATE DATABASE的完整语法 CREATE DATABASE <NewDataBase> [ON [PRIMARY] ([NAME = <'logical file name'>,] FILENAME = <'file name'> [, SIZE = <size in ki...
Creates a new database. Select one of the following tabs for the syntax, arguments, remarks, permissions, and examples for a particular SQL version with which you are working. Select a product In the following row, select the product name you're interested in, and only that product's infor...
USE master; GO sp_detach_db Archive; GO CREATE DATABASE Archive ON (FILENAME = 'D:\SalesData\archdat1.mdf') FOR ATTACH ; GO F. 创建数据库快照 以下示例创建数据库快照 sales_snapshot0600。由于数据库快照是只读的,所以不能指定日志文件。为了符合语法要求,指定了源数据库中的每个文件,但没有指...
Specifies that the disk files used to store the data sections of the database, data files, are explicitly defined. ON is required when followed by a comma-separated list of <filespec> items that define the data files for the primary filegroup. The list of files in the primary filegroup can...
It uses the default database file sizes you have defined for the SQL Server model database or 500 MB for the MDF file and 125 MB for the LDF file, whichever is greater. If you choose to create a geodatabase in a schema named sde, the tool creates an sde database-authenticated log...
USEmaster;CREATE<database-name> The following creates 'HR' database. USEmaster;CREATEDATABASE'HR'; The Following create 'HR' database with data and log files. USEmaster;CREATEDATABASE[HR]ON(NAME=N'HR',FILENAME=N'C:Program FilesMicrosoft SQL ServerMSSQL15.SQLEXPRESSMSSQLDATAHR.mdf',SIZE...
The nonscalar types, cursor and table, can't be specified as a parameter data type in either Transact-SQL or CLR functions. If type_schema_name isn't specified, the Database Engine looks for the scalar_parameter_data_type in the following order: The schema that contains the names of SQL...
判断题(共40题,20.0分)72. (0.5分) create database studentinfo on (filename=' d:\ mdf', size=2MB,maxsinz=5MB) 中数据库初始大小2MB,最大大小5MB。 A 对 B 错 相关知识点: 试题来源: 解析 数据库的初始大小为2MB,最大大小为5MB。这意味着当数据库需要存储更多的数据时,它可以自动扩展到5MB,...
The nonscalar types, cursor and table, can't be specified as a parameter data type in either Transact-SQL or CLR functions. If type_schema_name isn't specified, the Database Engine looks for the scalar_parameter_data_type in the following order: The schema that contains the names of SQL...
The nonscalar types, cursor and table, can't be specified as a parameter data type in either Transact-SQL or CLR functions. If type_schema_name isn't specified, the Database Engine looks for the scalar_parameter_data_type in the following order: The schema that contains the names of SQL...