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

crobinson2013

  • Hero Member
  • *****
  • Posts: 535
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
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
 

Did you know?

Sildenafil (Viagra®) has two actions that may be of consequence in patients with heart disease. It can lower the blood pressure, and it can interact with nitrates. It should never be used in patients who are taking nitrates.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

For a complete list of videos, visit our video library