Question Not sure what they are asking

[Rogueci5]

Hi Guys

I am onto my second IT course and I have a question which states:

In your organisation, what situations might require the creation of customised SQL syntax?

I am really not sure what they are after. And it is an external course, so there’s no quick answers from the course providers.

I think they want to know where we have had to use SQL to provide information from databases we have built, but is there another meaning to the "Customised SQL Syntax?"

Kind of lost
Cheers

 

[Uncle Gizmo]

It doesn't ring any bells with me.

I think the correct answer will be related to the context of your IT course.

Sent from my SM-G925F using Tapatalk

 

[Rogueci5]

It doesn't ring any bells with me.

I think the correct answer will be related to the context of your IT course.

Thank you! I think I might just go with a description of what I have built and the SQL used to draw the information.

Not sure what else to do

Cheers

 

[jdraw]

I'm not sure of what the course expectation is, but I did try Google using this criteria
Customised SQL Syntax.

Try it yourself. It seems that it may be a reference specific to Tableau software, but it may mean a Parameter query.
I suggest you try google and then the returned links to see if any relate to the course and question involved.

Good luck.

 

[Rogueci5]

I'm not sure of what the course expectation is, but I did try Google using this criteria
Customised SQL Syntax.

Try it yourself. It seems that it may be a reference specific to Tableau software, but it may mean a Parameter query.
I suggest you try google and then the returned links to see if any relate to the course and question involved.

Good luck.

Hi jdraw

Yeah I did use google, and as you say there were links simular or the same as you have stated. None of them "seemed" to be relevant though :banghead:

The course is for Cert 4 in IT and SQL is one of the modules, so it’s the basics really.

I will have another look at the Parameter query tho!

Cheers

 

[Uncle Gizmo]

I also had a search of the Internet and couldn't find anything directly related to "customised SQL syntax" or even "custom SQL syntax" so I suspect it's a red herring to stop you getting any benefit from Googling. I suspect it's just fancy wording; which just means "Create your own SQL statement in text form in VBA function"... But if you get the answer wrong don't blame me!

 

[Rogueci5]

But if you get the answer wrong don't blame me!

No problems mate! I will just describe what we have done and see what the fall out is

Cheers

 

[The_Doc_Man]

If you were using Access or Paradox and built all your queries with a grid-like "query by example" builder or a query wizard, that would be something built by the DB manager tool. I would interpret the question as asking for any SQL action or select queries that could not be built using automation.

 

[stopher]

Syntax to me has quite a specific meaning i.e. the vocabulary of the database engine. You can't change it afaik. It's deeply embedded. So the notion of "custom" SQL syntax does seem very strange. All I can think of is if you were using another D/B engine other than the main one you were using then you may have to change the syntax. Not sure I'd use the word "custom" in this scenario though.

 

[Rogueci5]

I would interpret the question as asking for any SQL action or select queries that could not be built using automation.

Good point mate thank you!

@ stopher yes I agree, that why I asked here for help I will look into the above from The_Doc-Man tho!

Cheers
Guys very helpful!