News for hackers. Stuff that matters.
Re:SQL Tips and Tricks by password4321 on Thursday September 26, 2024 @12:51AM (#41654648)
Are you able to cast as XML? I use that for OBJECT_DEFINITION, eg.

  select name,cast((select OBJECT_DEFINITION(object_id) for xml path('')) as xml) from sys.procedures  
This can be easier to straighten out since it preserves the newlines though other XML characters get mangled like > to >. One other option is VARBINARY plus something to un-hex it.

There are no comments on this comment yet.