January 12, 2017 at 8:32 pm
Comments posted to this topic are about the item U-SQL data types
January 13, 2017 at 1:11 am
Steve Jones - SSC Editor - Thursday, January 12, 2017 8:32 PMComments posted to this topic are about the item U-SQL data types
Tricky one that, with the inclusion of JSON, forced me to think this early in the morning.
January 13, 2017 at 3:57 am
Will ARRAY ever be added to T-SQL?
Who would like to see it added?
January 13, 2017 at 7:30 am
I saw the "Select 2" after submitting my answer. :unsure:
January 13, 2017 at 7:34 am
martin.whitton - Friday, January 13, 2017 3:57 AMWill ARRAY ever be added to T-SQL?
Who would like to see it added?
Why? I don't see any benefit to ARRAY over a properly defined parent-child relationship.
If you don't want to take the time to construct a normalized database structure, you can already implement the features of ARRAY with XML or JSON data.
January 13, 2017 at 8:50 am
Luis Cazares - Friday, January 13, 2017 7:30 AMI saw the "Select 2" after submitting my answer. :unsure:
Ugh, me too. :pinch::doze:
January 13, 2017 at 8:57 am
I'm inclined to agree with you, but I asked the question because ARRAY is in the ANSI SQL standard.
The following quote comes from SQL:1999 , formerly known as SQL3 :
January 13, 2017 at 9:23 am
I've never used U-SQL, so I used the logic of what's not in T-SQL.
January 13, 2017 at 9:24 am
sknox - Friday, January 13, 2017 7:34 AMmartin.whitton - Friday, January 13, 2017 3:57 AMWill ARRAY ever be added to T-SQL?
Who would like to see it added?Why? I don't see any benefit to ARRAY over a properly defined parent-child relationship.
If you don't want to take the time to construct a normalized database structure, you can already implement the features of ARRAY with XML or JSON data.
Or a table - temp or otherwise.
January 15, 2017 at 7:30 pm
Ed Wagner - Friday, January 13, 2017 9:23 AMI've never used U-SQL, so I used the logic of what's not in T-SQL.
Neither have I, but:
As there are 3 not in T-SQL, that gives you only 2 chances in 3 or getting it right. So I decided to see which of those 3 was not in U-SQL. Nice safe aproach.
Tom
February 24, 2017 at 1:01 pm
I found this one helpful in that I am a noob with U-SQL. Thanks for the lesson.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy