replace single quotes in select statement

  • 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.

  • 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.

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

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