Updating a field in sql
The second row is the row that defines the changes made to the database fields using the keyword SET followed by the column name, equal sign and the new value for this column.
The error message is: Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E14) The identifier that starts with 'Long list of text that i'm trying to insert' is too long. This is because you are delimiting a string literal with double quotes.Is there a way around this or a particular update i should be using? Retrieving data and writing basic data back is fine, however, when i go to update one table that has a text field in it the update fails if the amount of data being passed to the text field is too large.Is there a way around this or a particular update i should be using? Cheers Bj Hi Vinod, The amount of data being passed to the update is on average about 2 or 3 paragraphs worth of data (in the one i was trying to insert there was about 1000 characters including whitespace).So far we only looked at retrieving data from SQL database, but we never talked about modifying/updating data.The SQL UPDATE command is used to modify data stored in database tables.