« previous next »

Author Question: In addition to the standard SQL Server 2014 tools, SQL statements such as CREATE TABLE can now also ... (Read 46 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 term bacteria was devised in the 19th century by German biologist Ferdinand Cohn. He based it on the Greek word "bakterion" meaning a small rod or staff. Cohn is considered to be the father of modern bacteriology.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

People about to have surgery must tell their health care providers about all supplements they take.

Did you know?

The National Institutes of Health have supported research into acupuncture. This has shown that acupuncture significantly reduced pain associated with osteoarthritis of the knee, when used as a complement to conventional therapies.

The ovaries. In addition to producing ova, the ovaries secrete the female sex hormones, estrogen and The ovaries. In addition to producing ova, the ovaries secrete the female sex hormones, estrogen and
The testes. In addition to producing sperm, the testes secrete the male sex hormones, primarily test The testes. In addition to producing sperm, the testes secrete the male sex hormones, primarily test
Asthma. (a) A normal bronchiole. (b) An asthmatic bronchiole. During an asthma “attack,” the bronchi Asthma. (a) A normal bronchiole. (b) An asthmatic bronchiole. During an asthma “attack,” the bronchi
How to manually find the mean, variance, and standard deviation for a set of numbers How to manually find the mean, variance, and standard deviation for a set of numbers
The periodic cylinder of the elements. When the periodic table is folded in such a way that the ... The periodic cylinder of the elements. When the periodic table is folded in such a way that the ...
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 + ...
Video: Electrical Conduction System of the Heart

For a complete list of videos, visit our video library