The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

User-Defined Functions Syntax Inconsistence

Back to all questions

User-Defined Functions Syntax Inconsistence

7 months ago
Vote Up Vote Down
0
Votes
1
Answer

Hi!
I came across a little inconsistence in terms of body content when coding user-defined function. Please note that in accordance to the Syntax Pattern the DECLARE part is outside the body, but when coding the example, DECLARE part comes after BEGIN statement (so becomes the part of the body).
Are both ways correct?
Thanks in advance!
Justyna
 
 

#, #, #
1 Answer

365 Team 7 months ago
Vote Up Vote Down
0
Votes

Hi Justyna!
Thanks for reaching out.
Thank you for pointing this out. This is something we have to correct and upload, and we will do it.
First you need to use BEGIN, and then – DECLARE. I.e. the DECLARE Statement needs to be within the BEGIN-END block.
Hope this helps.
Best,
Martin

You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #, #, #.

×
Complete Data Science Training
Save 60%