« previous next »

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

During the twentieth century, a variant of the metric system was used in Russia and France in which the base unit of mass was the tonne. Instead of kilograms, this system used millitonnes (mt).

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Periodic Table Tattoo Periodic Table Tattoo
Standard Medical Record and Types of Reports Found in Record Standard Medical Record and Types of Reports Found in Record
Assisting the patient to transfer from the bed or examining table to a wheelchair. Assisting the patient to transfer from the bed or examining table to a wheelchair.
A. Open portable massage table on its side. B. Straighten out legs completely and check that leg ... A. Open portable massage table on its side. B. Straighten out legs completely and check that leg ...
Apply draining stroke to forearm. Hold forearm off of the table with one hand. With the other hand, ... Apply draining stroke to forearm. Hold forearm off of the table with one hand. With the other hand, ...
ANOVA Table ANOVA Table
Video: Arthritis

For a complete list of videos, visit our video library