« previous next »

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

Women are 50% to 75% more likely than men to experience an adverse drug reaction.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

The modern decimal position system was the invention of the Hindus (around 800 AD), involving the placing of numerals to indicate their value (units, tens, hundreds, and so on).

Urinalysis. During a simple urinalysis, a stick with colored blocks is dipped into a urine specimen. Urinalysis. During a simple urinalysis, a stick with colored blocks is dipped into a urine specimen.
Standard Model of Elementary Particles Standard Model of Elementary Particles
Height and weight table Height and weight table
Standard Medical Record and Types of Reports Found in Record Standard Medical Record and Types of Reports Found in Record
Example of the Table of Neoplasms. Example of the Table of Neoplasms.
Body mass index table. Body mass index table.
Video: The Vestibular System

For a complete list of videos, visit our video library