U-SQL data types

Question

U-SQL data types

Steve Jones - SSC Editor

SSC Guru

Points: 738063
More actions
January 12, 2017 at 8:32 pm

#77488

Comments posted to this topic are about the item U-SQL data types

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

BillLudlow SSCertifiable Points: 6553 More actions · Answer 1

Steve Jones - SSC Editor - Thursday, January 12, 2017 8:32 PM
Comments 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.

Louisa Whitton SSCrazy Points: 2577 More actions · Answer 2

Will ARRAY ever be added to T-SQL?
Who would like to see it added?

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

I saw the "Select 2" after submitting my answer. :unsure:

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

sknox SSChampion Points: 12388 More actions · Answer 4

martin.whitton - Friday, January 13, 2017 3:57 AM
Will 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.

sestell1 SSChampion Points: 10230 More actions · Answer 5

Luis Cazares - Friday, January 13, 2017 7:30 AM
I saw the "Select 2" after submitting my answer. :unsure:

Ugh, me too. :pinch::doze:

Louisa Whitton SSCrazy Points: 2577 More actions · Answer 6

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 :

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

I've never used U-SQL, so I used the logic of what's not in T-SQL.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Ed Wagner SSC Guru Points: 287026 More actions · Answer 8

sknox - Friday, January 13, 2017 7:34 AM
martin.whitton - Friday, January 13, 2017 3:57 AM
Will 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.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

TomThomson SSC Guru Points: 104773 More actions · Answer 9

Ed Wagner - Friday, January 13, 2017 9:23 AM
I'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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

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

U-SQL data types

Cookies on SQLServerCentral