« previous next »

Author Question: In addition to the standard SQL Server 2014 tools, SQL statements such as CREATE TABLE can now also ... (Read 45 times)

crobinson2013

  • Hero Member
  • *****
  • Posts: 535
on: Jul 7, 2018
In addition to the standard SQL Server 2014 tools, SQL statements such as CREATE TABLE can now also be executed by using Microsoft's PowerShell.
 
  Indicate whether the statement is true or false

Question 2

Describe why SQL Server 2014 is sensitive to certain words being used in SQL commands or scripts, and what to do about it.
 
  What will be an ideal response?


Chelseyj.hasty

  • Sr. Member
  • ****
  • Posts: 319
Reply #1 on: Jul 7, 2018
Answer to Question 1

TRUE

Answer to Question 2

SQL Server 2014 has a set SQL keywords that are reserved words. Thus, SQL statements using these words may cause conflicts. For example, the SQL statement SELECT Select FROM From; would be difficult for SQL Server 2014 to work with. The solution is to either use modified versions of the words (SelectColumn, FromTable), or to enclose the SQL keywords that are used as table or column names in square brackets (Select, From).


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Did you know?

A good example of polar molecules can be understood when trying to make a cake. If water and oil are required, they will not mix together. If you put them into a measuring cup, the oil will rise to the top while the water remains on the bottom.

A portion of the periodic table of elements A portion of the periodic table of elements
Arthroscopic surgery involves the surgery of a joint with the use of a flexible arthroscope and othe Arthroscopic surgery involves the surgery of a joint with the use of a flexible arthroscope and othe
In this 1900 cartoon, oil baron John D. Rockefeller holds the White House in the palm of his hand wh In this 1900 cartoon, oil baron John D. Rockefeller holds the White House in the palm of his hand wh
Carrie Mae Weems, Untitled (Man Smoking/Malcolm X), from The Kitchen Table Series. Carrie Mae Weems, Untitled (Man Smoking/Malcolm X), from The Kitchen Table Series.
Standard Precautions for the Care of all Patients in All Health Care Settings Standard Precautions for the Care of all Patients in All Health Care Settings
8.The following table contains DNA-sequence information compiled by Marilyn Kozak (1987). The ... 8.The following table contains DNA-sequence information compiled by Marilyn Kozak (1987). The ...
Video: Natural Selection, Species Isolation and Real World Example

For a complete list of videos, visit our video library