The U-SQL SQL.MAP

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  March 13, 2017 at 10:09 pm

  #74558

  Comments posted to this topic are about the item The U-SQL SQL.MAP

• Stewart "Arturius" Campbell

  SSC Guru

  Points: 72710

  More actions

  March 14, 2017 at 7:13 am

  #1933028

  Really need to get stuck in and learn U-SQL
  thanks for the question, Steve, learned something today

  ____________________________________________
  Space, the final frontier? not any more...
  All limits henceforth are self-imposed.
  “libera tute vulgaris ex”

• Revenant

  SSC-Forever

  Points: 42467

  More actions

  March 14, 2017 at 3:33 pm

  #1933154

  I wish these types were available in T-SQL, too.

  Thanks, Steve!

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  March 30, 2017 at 4:03 pm

  #1935877

  Revenant - Tuesday, March 14, 2017 3:33 PM

  I wish these types were available in T-SQL, too.

  Thanks, Steve!

  Does it count for tsql if we have "maps" exposed via extended events? :Whistling:

  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

• Revenant

  SSC-Forever

  Points: 42467

  More actions

  March 30, 2017 at 4:13 pm

  #1935882

  SQLRNNR - Thursday, March 30, 2017 4:03 PM

  Revenant - Tuesday, March 14, 2017 3:33 PM

  I wish these types were available in T-SQL, too.

  Thanks, Steve!

  Does it count for tsql if we have "maps" exposed via extended events? :Whistling:

  I think that extended events are meant for troubleshooting and they are good for just that.  Perhaps they could be used to emulate SQL.MAP but I do not like fighting my tools.

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  March 30, 2017 at 5:02 pm

  #1935886

  Revenant - Thursday, March 30, 2017 4:13 PM

  SQLRNNR - Thursday, March 30, 2017 4:03 PM

  Revenant - Tuesday, March 14, 2017 3:33 PM

  I wish these types were available in T-SQL, too.

  Thanks, Steve!

  Does it count for tsql if we have "maps" exposed via extended events? :Whistling:

  I think that extended events are meant for troubleshooting and they are good for just that.  Perhaps they could be used to emulate SQL.MAP but I do not like fighting my tools.

  It was a bit tongue in cheek. The XE map is an array of values just like the SQL.MAP but XE is really for other uses.

  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