Help in inserting quotes in database

Question

hi, can anybody please tell me how do i insert a string which has quotes in it string. i know that we have to use double quotes before the apostrophe, but the problem is i have to insert 100 rows , each having 80 columns and the the apostrophe can occur in any of these 80 columns. . so shld i check for each column, whether it has a 'quote or not' for each row . please help thanx in advance

Answer 1

For 'Real World' applications - most of the value of the system arises from the mid-tier (with the business layer). This is where the business logic which provides the requirement solutions resides. My suggestion would be to obtain as much experience with this tier - a recommended book is Lhotka's Business Objects (this is NOT the 'Business Objects Enterprise/Crystal Reports' from SAP which sucks). Lhotka's approach is very unique and is well documented  - more details here: http://www.lhotka.net/

Post your experiences here..
Good Luck!

SBC
Microsoft MVP - Groove:Architecture