replace single quotes in select statement

Question

replace single quotes in select statement

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

James Raddock Mr or Mrs. 500 Points: 569 More actions · Answer 1

This is really a hack but, I'd suggest connecting to your database with microsoft access and then copying directly from BIDS to your table [through a linked table]. Then you wouldn't have to escape the quotes.

John Beggs SSCommitted Points: 1921 More actions · Answer 2

From what I gather reading all of the posts here, you are putting the info into a DB just for record keeping, correct?

If that is the case, is there a reason you don't just create/save a project in BIDS? Doing this would allow you full and simple re-use of your code as well as ample space to maintain formatting and documentation. There are many other advantages to this, but if you are using the info in the DB for more than just documentation, it all becomes moot.