Hi! I am kind of a noob to SQL! Sort of. I get paid to do it for a living, but I'm on the noobish end of people who get paid to do SQL lol. Anywho, I have a question. So I like to read my peers SQL queries to understand SQL better and I am kind of stuck on one that I read today. She used html within the SQL code. Specifically, I saw an <a> and an <href>. I'm lost. Why would somebody need to put HTML in a secure database???

Posting as :
works at
You are currently posting as works at

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.

like

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.

Related Posts

How's work in industry as a senior tax analyst (specifically federal corporate tax and ASC 740)?
Work hours? Pay? Pros and Cons to leaving Public? Thanks for the help!

like

PwC India Anyone who recently joined pwc India bangalore data analytics team can you tell me how’s the WLB and growth here !?PwC India PwC

like

Started as a BDR and got moved into partnerships within the same org. Comp was initially 75k CAD with OTE 120K CAD. New comp for new partner channel I am carving out, I am offered same base but guaranteed 75% quota attainment payout. Is this a fair comp? Would love any constructive thoughts/points on this. Company is in eComm vertical

like

What is the equivalent of L7 at Pepsico in Accenture or Deloitte USI ?

like

Amazons excessive interviews are an awful candidate experience. Why do they think this will help them win top talent in this competitive environment? Especially with their public cultural issues…? Lots of great paying companies without having to take a day off from work to interview! It’s overkill

like

How do you handle billing disputes? Already feel like we’re a steal compared to other firms, but it’s the pits when clients kvetch about the bill after working hard on their matters. For five figure disputes, anyone recommend collections? Don’t really want to institute retainers, especially since it doesn’t seem common for our practice area.

like

I interviewed at a small local firm on December 3. They originally said two weeks so I contacted them December 18 and then they said they would have a decision this week. Continued...

like

I've gotten feedback that I'm too honest in my interviews, is that really a con for future employers? 🫤 How do I refrain from doing that anymore?

like

McKinsey 🐠: how much did you practice before your case interviews? (i.e. how many weeks / months in advance, how many hours per week, etc?) any tips on most effective ways to prep as an experienced hire coming in at the associate level? (No MBA or finance background so may need some extra prep to learn key concepts / terms)

like

Hi all!
Want to break into IB in London (BB's and EB's) as an Associate.
Anyone willing to refer or can share any info?

Thanks!

like

Where should I invest money ?
Apart from shares and mutual funds.

Note: max amt - 20 lakhs
Need good return
Blocking period can be of 5-7 years..

Any ideas for discouraging students from using Google translate, or like services? I tell students they need to rely on their brains, after all it is the original computer. Ask “What would they do if they have no signal, in a foreign country and are lost?” They continue to use it. Other teachers in my department don’t see it as an issue...any helpful suggestions are welcome.

How are you encouraging students to DO science while remote learning? When online, most of my students stay muted and won’t collaborate. Also, most “labs” have turned into analyzing data instead of student-led.

like

Does PWC India consider counter offer or drop the candidature if they cannot match the CTC?

like

Hi all, Which company is good to join ? if offer is almost same based on work life balance, flexible working hour, work culture.

1. Cognizant
2. TCS
3. Capgemini

like

Advice on managing up / enduring toxic deal teams? I’m at the point where my stomach drops any time I see something come in from certain people. Everything is behind, client is unhappy, I’m exhausted and simultaneously being micromanaged without guidance on big-picture/substantive issues. I keep trying to tell myself at least this is consulting and the project will be over... eventually...

like

Any recommendations for a personal trainer? Looking for someone for 1:1 classes in South Boston. Thanks

like

One of the company asked if i could join as early as in 1.5/2 months where I have 3 months NP and haven't put papers yet .. i asked one of my senior in my team about this who's already resigning...and she has told about this to the entire team 😶. I realise it's my mistake asking her :p
Now that I'm not hearing back from the company which I gave interview and my environment at current project is a mess atm...Should I just put papers or bear with it till I fine another one..??

like

I recently got an IBM offer letter. There are 3 options i.e. Accept, Decline and Query.
I had selected the Query option to change my joining date which they did with e mail.
But now in the offer letter section, it does not show the 3 options anymore. But I both have the offer letter and the revised joining date e mail. Is it okay?

like

Bought $0.50 worth of XRP in 2013 and promptly forgot about it. Now worth $172. 35,000% gain.

like

Additional Posts in SQL Server

Hello All, if you had the opportunity to explain SQL in a nut shell, what would you say.

Scenarios would be helpful.

like

How do you personally explain the difference between Cross Apply and Cross Join?

I am currently recruiting for DBA’s for both SQL Server and Azure SQL DB. What questions should I be asking?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal