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?
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]).
You might also like to view...
A person's personality portrays the "whole person" interacting with his or her environment
Indicate whether the statement is true or false
The formula holds that each cross-tabulation cell expected frequency be subtracted from its associated observed frequency, and then that difference be squared to avoid a cancellation effect of minus and plus differences
Indicate whether the statement is true or false