Database Web Apps
Queries Cursors Views
Writing Logic Queries
Dynamic SQL Statements
Retrieving Data Multiple Tables
Multiple Table Retrieval
Alternate Queries Aliases
Inserting Data Transact SQL
SQL Statement Punctuation
Inserting Values from another Table
Updating Values from differentr Table
Indexing Query Strategies
Full Text Searching
Defining Full Text Indexes
Implement Full Text Search
Issue Insert Information in SQL-Server
Punctuation in SQL
SS has asked you to update Anthony Mann with new salary information, and you issue the <tt>INSERT</tt> statement shown above.
Notice that the literal values for FirstName and LastName are enclosed in quotes (single quotes to be exact), whereas the literal value for Salary is not. This is because SQL Server requires quotations for the character datatype, but not for the money datatype.
Next, note that the literal value for Salary does not have a dollar sign. This is because punctuation is necessary with literal values only when its omission will change the definition of the value, such as with a decimal. It is important to only use necessary punctuation with literal values.