• 首页 首页 icon
  • 工具库 工具库 icon
    • IP查询 IP查询 icon
  • 内容库 内容库 icon
    • 快讯库 快讯库 icon
    • 精品库 精品库 icon
    • 问答库 问答库 icon
  • 更多 更多 icon
    • 服务条款 服务条款 icon

创建数据库 - 其他参数的真正目的是什么意思

用户头像
it1352
帮助1

问题说明

 大家好, 

 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. 

正确答案

#1

  ;大家好, 

 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

(然后验证它是否存在)。

(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

这篇好文章是转载于:学新通技术网

  • 版权申明: 本站部分内容来自互联网,仅供学习及演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,请提供相关证据及您的身份证明,我们将在收到邮件后48小时内删除。
  • 本站站名: 学新通技术网
  • 本文地址: /reply/detail/tanhcgkbcb
系列文章
更多 icon
同类精品
更多 icon
继续加载