Print function problems

[Guest_imported]

Hi all,

I'm trying to write a script to extract the DDL for a trigger, given the table name.

The main problem I encounter is with the print function. First to replace the char(10), (I think I solved this with the stuff function) but now I'm trying to print lines containing the "%" char, that SQL understand as a formatting for the print and mess it all up.

Any suggestion?


Thanks,
Roberto

 

[Guest_imported]

Hi,
I solved this issue by using a temp table and inserting row by row into that table and at the end, selecting the whole of it or in my case, doing a bcp out to a file.
Thus to avoid the print.

Regards,
Roberto