Author Question: In addition to the standard SQL Server 2014 tools, SQL statements such as CREATE TABLE can now also ... (Read 13 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?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

For a complete list of videos, visit our video library