CREATEDATABASEdatabase_snapshot_nameON(NAME=logical_file_name,FILENAME='os_file_name') [ ,...n ]ASSNAPSHOTOF[;] 参数 database_name 这是新数据库的名称。 数据库名称在 SQL Server 的实例中必须是唯一的,并且必须符合标识符规则。 除非没有为日志文件指定逻辑名称,否则 database_name 最多可以包含...
database_name 這是新資料庫的名稱。 資料庫名稱在 SQL Server 的執行個體內必須是唯一的,且必須符合識別碼的規則。 除非沒有指定記錄檔的邏輯名稱,否則database_name最多可有 128 個字元。 如果未指定邏輯記錄檔名稱,SQL Server 會就藉由在database_name附加後置詞,來產生記錄檔的logical_file_name和os_file_...
Create a database snapshot syntaxsql Copy CREATE DATABASE database_snapshot_name ON ( NAME = logical_file_name, FILENAME = 'os_file_name' ) [ ,...n ] AS SNAPSHOT OF [;] Arguments database_name The name of the new database. Database names must be unique within an instance of...
on theDatabasemenu, point toOptions, clickModeling, and then on theLogical Diagramtab in theDatabase Modeling Preferencesdialog box underWhen removing an object from the diagram, clickAsk User What To Do. Alternatively, if you want to remove the view from the model, click...
If creating a UDF that doesn't access data, specify the SCHEMABINDING option to prevent the query optimizer from generating unnecessary spool operators for query plans involving these UDFs. For more information on spools, see Showplan Logical and Physical Operators Reference. For more information on ...
In this article, you'll create entity schemas for physical and logical entities. What's the difference between the two?展開資料表 Entity typeDescription Physical The entities that exist in your data, often as tables in a database. This means that the entity schemas that you'll create for ...
有效参数由D3D12DDICAPS_TYPE_VIDEO_0020枚举的D3D12DDICAPS_TYPE_VIDEO_0053_MOTION_ESTIMATOR功能检查确定。 要求 要求价值 最低支持的客户端Windows 10 版本 1809 标头d3d12umddi.h 反馈 此页面是否有帮助? 是否 提供产品反馈| 在Microsoft Q&A 获取帮助...
Is the name of the new database. Database names must be unique within an instance of SQL Server and comply with the rules for identifiers. database_name can be a maximum of 128 characters, unless a logical name is not specified for the log file. If a logical log file name is not sp...
Is the name of the new database. Database names must be unique within an instance of SQL Server and comply with the rules for identifiers. database_name can be a maximum of 128 characters, unless a logical name is not specified for the log file. If a logical log file name is not sp...
There are two types of schema: physical schema (how data is stored) and logical schema (how data is logically organized). In relational databases, the schema includes the presence of tables, views, indexes, and stored procedures. A good database schema design makes for efficient management and...