Saturday, July 16, 2011

How do i use a field name in SQL if its a type of keyword in an INSERT command?

One possible workaround is if you are inserting values into every column of the table...if so, just don't specify the column list. The catch is that then you have to make sure that the values are in the exact same order that the columns are defined in the database so that each value maps into the appropriate column.

No comments:

Post a Comment