« previous next »

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

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Did you know?

Vital signs (blood pressure, temperature, pulse rate, respiration rate) should be taken before any drug administration. Patients should be informed not to use tobacco or caffeine at least 30 minutes before their appointment.

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Kara Walker, Insurrection! (Our Tools Were Rudimentary, Yet We Pressed On). Kara Walker, Insurrection! (Our Tools Were Rudimentary, Yet We Pressed On).
Standard reduction potentials of the major respiratory electron carriers Standard reduction potentials of the major respiratory electron carriers
Use a compound angle addition formula to determine an equivalent trig expression for cos(x + ... Use a compound angle addition formula to determine an equivalent trig expression for cos(x + ...
table table
Table - Correlation Analysis Table - Correlation Analysis
Table salt. Table salt.
Video: DNA Sequences - Dideoxy Sequencing

For a complete list of videos, visit our video library