« previous next »

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

The cure for trichomoniasis is easy as long as the patient does not drink alcoholic beverages for 24 hours. Just a single dose of medication is needed to rid the body of the disease. However, without proper precautions, an individual may contract the disease repeatedly. In fact, most people develop trichomoniasis again within three months of their last treatment.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Blank periodic table Blank periodic table
Table of Ionic Charges Table of Ionic Charges
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
Nucleophilic addition reaction of aldehydes and ketones Nucleophilic addition reaction of aldehydes and ketones
Seven bacteriophage deletion mutations (1 to 7 in the table below) are tested for their ability ... Seven bacteriophage deletion mutations (1 to 7 in the table below) are tested for their ability ...
Table - Correlation Analysis Table - Correlation Analysis
Video: Phases of an Action Potential - Resting Potential, Threshold, Rising, Falling, & Recovery Phases

For a complete list of videos, visit our video library