创建数据库 - 其他参数的真正目的是什么 [英] creating database - what is the real purpose of additional parameters

问题描述

 大家好， 

 Hi all, 

我正在查看Microsoft文档中的CREATE DATABASE  https://docs.microsoft.com/en-us/sql/t-sql/statements / create-database-transact-sql？view = sql-server-2017  

I'm looking at CREATE DATABASE at Microsoft docs https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=sql-server-2017 

并且第一个例子说它已经足够了

and the very first example says that it is enough 

USE
master ;
GO IF DB_ID（N'mytest'）IS NOT NULL DROP
DATABASE
mytest; GO CREATE
DATABASE
mytest; GO

USE master; GO IF DB_ID (N'mytest') IS NOT NULL DROP DATABASE mytest; GO CREATE DATABASE mytest; GO

（然后验证它是否存在）。

(then verify that it exists).

在上述链接中，您可以看到使用其他参数的更多示例。 

Also on that mentioned link you can see more examples using additional parameters. 

所以...请帮助我理解，这些附加参数的真正目的是什么以及为什么应该让某人需要他们。简单。请告知。 

So... help me please to understand, what is the real purpose of those additional parameters and why exactly should someone need them. Briefly. Please advise. 

推荐答案

  ;大家好， 

 Hi all, 

我正在查看Microsoft docs的CREATE DATABASE  https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-transact- sql？view = sql-server-2017  

I'm looking at CREATE DATABASE at Microsoft docs https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=sql-server-2017 

，第一个例子说它已经足够了

and the very first example says that it is enough 

USE
master ;
GO IF DB_ID（N'mytest'）IS NOT NULL DROP
DATABASE
mytest; GO CREATE
DATABASE
mytest; GO

USE master; GO IF DB_ID (N'mytest') IS NOT NULL DROP DATABASE mytest; GO CREATE DATABASE mytest; GO

（然后验证它是否存在）。

(then verify that it exists).

下面你可以看到更多使用其他参数的例子。 

Also below you can see more examples using additional parameters. 

所以......请帮助我理解，这些附加参数的真正目的是什么以及为什么有人需要它们。简单。请告知。 

So... help me please to understand, what is the real purpose of those additional parameters and why exactly should someone need them. Briefly. Please advise. 

美好的一天，

首先，您的代码看起来不像您的代码很乱，而且不可读。请将您的代码再次与文档进行比较！您将在语句中间移到新行并将语句组合在同一行... Awuful
代码...真的  ;凌乱 

First of all, your code does not look like the documentation. Your code is messy and unreadable. Please compare your code to the documentation again! You move to new line in the middle of statements and combine statements together in the same line... Awuful code... really messy 

>>  这些附加参数的真正目的是什么以及为什么有人需要它们。简单。请告知。

>> what is the real purpose of those additional parameters and why exactly should someone need them. Briefly. Please advise. 

答案在链接中！您是否希望我们在此处复制文档？这是exac你在文件中有什么。

The answer is in the link! Do you want us to copy the documentation here? This is exactly what you have in the document.

检查"参数"部分。这是大部分文件。每个 参数都在那里解释。
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=sql-server -2017＃arguments

check the section of the "arguments" which is most of the document. Each argument is explained there
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-transact-sql?view=sql-server-2017#arguments

如果有明确的具体解释，我们可以尝试澄清，但我们不能在论坛的一条消息中写一本书，而且问题的答案正是文档带给你的

If there is specific explanation that is not clear then we can try to clarify, but we cannot write a book in one message in the forum, and the answer to the the question is exactly what the doc brings you

这篇关于创建数据库 - 其他参数的真正目的是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！