Related Posts
Additional Posts in SQL Server
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

Can you supply more context on the query or application? The first two things that come to mind are a website builder (though there's better ways) or webscraping storage.
It is definitely not a website builder. This is an EHR system. And I saw another table today that appeared to use this type of coding quite frequently. There were several columns within the table which were whimsically titled "ineedanhref345" I wonder if she is pulling external data
Weird. Is it part of some interface with an external system? Is it an internal tool?
Oh wait href is just an attribute of the anchor element and wouldn't be written as <href>.
Could this be part of an xml processing system? Sql server supports xml processing "natively" so unless this is really old code I'm still having trouble understanding why, but it's the only thing that makes sense. They're parsing some html into an xml format nesting the href attribute in it one node below the corresponding anchor node.
So again, I'm a little noobish so idk what xml processing system specifically entails, but it is definitely SQL. However, we use power query to connect via XML
Sometimes those are used to create and set the structure of and/or frame of a notification or alert before values are supplied into the structure created.