SQL Server 2016 and JSON Support

The Discussion

• 

  I'm only 22 minutes into the video, and I am amused that I heard Jason Bourne when they were discussing @json, '$.Born',    !

• 

  I LOVE how he is doing the examples! I like that most typical use cases with increasing difficulty get covered one by one.  Great intro video.  Well done!

• 

  What shortcut to converts the JSON single line result into formatted JSON?

• 

  Can somebody please help me out in What shortcut to converts the JSON single line result into formatted JSON?

• 

  Great tutorial, at a perfect pace.

  Thank you

• 

  @Celso:Use Sql Operations Studio. It works there.

• 

  a

• 

  Code :-
  --------------------------------------
  
  DECLARE @Json NVARCHAR(MAX) = '
  [
  {
  "RigthNumber":"RC01","RowVersion":[0,0,0,0,0,87,205,88]
  },
  {
  "RigthNumber":"RC02","RowVersion":[0,0,0,0,0,87,205,89]
  }
  ]
  '
  
  SELECT RigthNumber
  ,RowVersion
  FROM
  OPENJSON (@Json)
  WITH (
  RigthNumber varchar(50) '$.RigthNumber'
  ,RowVersion timestamp'$.RowVersion'
  )
  
  Current OutPut (Wrong Data in RowVersion)
  -------------------------------------------
  RigthNumber RowVersion
  RC01 0x
  RC02 0x
  
  
  Expected OutPut
  -----------------
  RigthNumber RowVersion
  RC01 0x000000000057CD8C
  RC02 0x000000000057CD8D
  
  Query : i dont get proper data for timestamp data type,can you help me?
  datatype of RowVersion is timestamp

• 

  Very good explanation. Thanks.

• 

  json, '$.Born' will be the new Jason Bourne working title in 2019 :P

• 

  Could you please paste the SQL code, So I could try out.
  Appreciate your help this is great

• 

  @Celso:
  In Visual Studio, hit Enter (or Return Key) at the end of the JSON text

• 

  These demos worth the whole TSQL documentation about JSON

• 

  DECLARE @json NVARCHAR(MAX) =
  N'{
  "Name": "Vlade",
  "Surname": "Divac",
  "Born": { "DoB": "1968-03-02", "Town": "Prijepolje", "Country": "Serbia"},
  "NBA Stat": {"pts": 13398, "ppg": 11.8, "rebounds": 9326, "rpg": 8.2, "blocks": 1631, "bpg": 1.4},
  "Teams": ["Los Angeles Lakers", "Sacremento Kings", "Partizan"],
  "Career":
  [{"team": "Sloga", "period":{"start": 1993, "end": 1986}},
  {"team": "Sloga", "period":{"start": 1993, "end": 1986}},
  {"team": "Los Angeles Lakers", "gp": 540, "gs": 450, "period":{"start":1989, "end":1996}},
  {"team": "Charlotte Hornets", "gp": 145, "gs": 121, "period":{"start":1996, "end":1998}},
  {"team": "Sacremento Kings", "gp": 454, "gs": 453, "period":{"start":1998, "end":2004}},
  {"team": "Los Angeles Lakers", "gp": 15, "gs": 0, "period":{"start":2004, "end":2005}}],
  "Bio":"Vlade Divac (Serbian Cyrillic: Владе Дивац, pronounced [ʋlǎːde dǐːʋats]; born February 3, 1968) is a Serbian professional basketball executive and former player who was most recently the vice president of basketball operations and general manager of the Sacramento Kings of the National Basketball Association (NBA). Divac spent most of his playing career in the NBA. At 7 ft 1 in (2.16 m),[1] he played center and was known for his passing skills. He was among the first group of European basketball players to transfer to the NBA in the late 1980s and was named one of the 50 Greatest EuroLeague Contributors.[2] He is one of seven players in NBA history to record 13,000 points, 9,000 rebounds, 3,000 assists, and 1,500 blocked shots, along with Kareem Abdul-Jabbar, Tim Duncan, Shaquille O''Neal, Kevin Garnett, Pau Gasol, and Hakeem Olajuwon.[3][n 1] Divac was also the first player born and trained outside the United States to play in over 1,000 games in the NBA. On August 20, 2010, he was inducted into the FIBA Hall of Fame in recognition of his play in international competition.[4] He was elected to the Naismith Memorial Basketball Hall of Fame in 2019.[5] Divac is a humanitarian, helping children in his native country of Serbia and in Africa.[6] In October 2008, he was appointed as government adviser in Serbia for humanitarian issues.[7] In February 2009, he was elected President of the Serbian Olympic Committee for a 4-year term[8] and re-elected in November 2012.[9] In 2013, Divac received an honor from the World Sports Humanitarian Hall of Fame.[10]Professional career Divac began playing basketball in his home town Prijepolje for the team KK Elan. He began his professional career in Yugoslavia playing for Sloga from Kraljevo, and was immediately noted for scoring 27 points against Crvena zvezda.[11] KK Partizan In the summer of 1986, Divac was the top star of the basketball transfer season, and he ended up signing with KK Partizan for DM14,000.[11] In the 1986-87 Yugoslav First League season, with players like Divac, Aleksandar Đorđević, Žarko Paspalj, Željko Obradović, and with coach Duško Vujošević at the helm, Partizan had a \"dream team\", which won the Yugoslavian League title. In the subsequent 1987-88 FIBA European Champions Cup season (now called EuroLeague), the club failed to reach the top of the EuroLeague, after having lost to Maccabi Tel Aviv in the semifinal in Ghent.[12] Jugoplastika, with Dino Rađa and Toni Kukoč, was a stronger team in the subsequent three years, reigning both in Yugoslavia and in Europe. Divac had an unusual style compared to most other centers of his generation: despite his height, he possessed good mobility, had good control of the ball, and was a decent shooter. On occasion, he would also act as a play maker. His trademark moves included a mid-range shot at the top of the key and flip shots around the rim, while facing the complete opposite direction. His quirky moves complemented how he liked playing gags on the court: in the 1989 EuroBasket, he lifted teammate Zoran Radović for a slam dunk. In just four professional seasons in Europe, he became the most sought-after big man on the continent, after Arvydas Sabonis.[11] Los Angeles Lakers Drafted into the NBA in 1989 by the Los Angeles Lakers, Divac became one of the first European players to have an impact in the league. Under the mentorship of Kareem Abdul-Jabbar and Magic Johnson, he improved his play and adapted to the American style of basketball. Though he spoke no English, he quickly became popular among his teammates and the public for his charm and joviality. In the 1989–90 season, he was selected into the NBA All-Rookie Team.[11] Divac earned a reputation for flopping, or deceiving the officials into calling a foul on the other team by purposely falling to the floor upon contact with an opposing player.[13] Veteran NBA forward P.J. Brown claimed that Divac might have been the best of all time at flopping.[14] Divac freely admitted doing so, adding that he usually did it when he felt like the officials had missed some calls and owed him.[15] However, when the NBA instituted anti-flopping penalties in 2012, Divac expressed his support for such rules, stating that he felt players after him were \"overdo[ing] it\" with respect to flopping.[16] Ian Thomsen, a Sports Illustrated columnist, grouped Divac with fellow international players Anderson Varejão and Manu Ginóbili as the players who \"made [flopping] famous\", exaggerating contact on the court in a manner analogous to diving in FIBA games.[17] Charlotte Hornets On July 1, 1996, Divac was traded to the Charlotte Hornets for the draft rights to Kobe Bryant and played two seasons there until signing with the Sacramento Kings in July 1998. Two games with KK Crvena zvezda During the 1998–99 NBA lockout, in January 1999, Divac played 2 games for Partizan''s eternal rival KK Crvena zvezda, in the 1998–99 EuroLeague season.[18] His debut for the crveno-beli took place mid-season, on Orthodox Christmas, versus a heavily favoured Žalgiris side led by Tyus Edney, Mindaugas Žukauskas, Saulius Štombergas, and Jiří Zídek Jr.. Supported by a raucous home crowd and energized by Divac''s arrival, as well as his 16 points and 8 rebounds, Crvena zvezda pulled off a 77–69 memorable upset win.[19] Divac''s brief stint with Crvena zvezda, for which he reportedly got paid US$250,000 per game,[19] immediately became a sore point with KK Partizan fans, who unfurled a banner calling him a traitor, at their club''s next game.[19]\\nThe issue of playing for the hated cross-town rival reignited several years later, when Divac returned to KK Partizan as club president. At the time, he stated his decision to play for Crvena zvezda was \"a mistake\".[19]Sacramento Kings\\nHe then signed as a free agent with the Sacramento Kings where he played for six seasons alongside fellow countryman Peja Stojaković. Teamed with Stojaković, Hedo Türkoğlu, Chris Webber and Mike Bibby, Divac revitalized the Sacramento Kings franchise. The Kings rose in the NBA ranks, becoming a perennial playoff contender and eventually a championship contender, leading the league in wins in 2001-02.[20] The Kings, however, could not get past the Los Angeles Lakers, who beat them in a 7-game series in 2002.[21]\\nReturn to the Lakers\\nAfter the 2003-04 NBA season, Divac became a free agent. He signed a deal to return to the Lakers, part of Mitch Kupchak''s plan to overhaul Laker basketball. The Lakers, following a defeat in the NBA Finals, had traded away or released most of their players, including Shaquille O''Neal, Gary Payton, Karl Malone, Derek Fisher, and more; Divac was supposed to help fill that void.\\nHowever, Divac suffered back problems and could not play most of the season, and even when he returned, could only play about nine minutes per game, averaging 2.3 points per game and 2.1 rebounds per game in 15 games, he played 8 games early in the season and 7 more in the final month of the season.\\nOn July 14, 2005, 37-year-old Divac announced his retirement, ending his 16-year NBA and 22-year professional basketball career.[22] Divac accepted a position with the Lakers as a European liaison to help with scouting overseas.\\nRetirement\\nThe Kings retired his No. 21 jersey in a ceremony on March 31, 2009.[23] Over his 16 years in the NBA, Divac earned over $93 million in salary.[24] In September 2009, he played for the \"NBA Generations\" team in the 2009 NBA Asia Challenge, a series of exhibitions against Korean Basketball League and Philippine Basketball Association players.[25]\\nNational team career\\nDivac with Dražen Petrović in the 1990 FIBA World Championship held in Argentina.\\nIn summer 1986, at 18, right after signing for KK Partizan, Divac debuted for the senior Yugoslavia national basketball team at the 1986 FIBA World Championship in Madrid, on invitation by the head coach Krešimir Ćosić. However, the excellent rookie''s performance was spoiled by the event in the semi-finals against the Soviet Union. Forty-five seconds before the end, Yugoslavia had a comfortable lead of 9 points, but the Soviets scored two three-pointers within a few seconds and cut the difference to 3 points. Yugoslavia tried to hold the ball for the remaining time, opting to continue the play with throw-ins instead of free throws following fouls, but with only 14 seconds left, Divac committed a double dribble, the Soviets were awarded the ball, and tied the score with another three-pointer. In the overtime, the Soviets won by 1 point and Yugoslavs had to be content with the bronze.[11][26]\\nThe next year, Divac participated in the team that took the gold at the 1987 FIBA Junior World Championship (which was later split into separate under-19 and under-21 events) in Bormio, Italy. That event launched the young generation of Yugoslavian basketball players, also featuring stars like Rađa and Kukoč, regarded as likely the best in history. Before the breakup of Yugoslavia, they would also take the titles at EuroBasket 1989 and the 1990 FIBA World Championship in Argentina,[11] where they were led by Dražen Petrović,[27] as well as the EuroBasket 1991 title, with Aleksandar Đorđević at point guard.[28]\\nDivac (fourth from right, at centre) with the Yugoslavia team that won the EuroBasket 1989.\\nWhen Yugoslavia won the gold in the 1990 FIBA World Championship, fans rushed onto the court. One of them was holding a Croatian flag, one of the six republics that made up Yugoslavia. Divac claims that he told the man that he should not be waving that flag, since this was a win for Yugoslavia. Divac claims the man made a derogatory remark about the Yugoslav flag, at which point Divac took his flag from him. This happened during a very tense time where nationalistic pride was threatening to tear Yugoslavia apart and ignite a war. The taking of the flag made Divac a hero to Serbs, and a villain to Croatians. Divac has stated that he did not mean it as an act against Croatia and he would have taken away a Serbian flag if a Serb fan had done the same.[29][30]\\nThis action, along with the Yugoslav Wars, alienated Divac from many of his former Croatian friends, particularly Dražen Petrović, whom he considered his best friend.[29] When FR Yugoslavia won the gold medal at the EuroBasket 1995, and Croatia won bronze, Croatia, still at war with Serbs from Croatia, walked off the podium during the medal ceremony. The teams had not faced each other in the tournament.\\nNBA career statistics\\nDivac is one of seven players in NBA history to record 13,000 points, 9,000 rebounds, 3,000 assists, and 1,500 blocked shots.\\nLegend\\n GP Games played GS Games started MPG Minutes per game\\n FG% Field goal percentage 3P% 3-point field goal percentage FT% Free throw percentage\\n RPG Rebounds per game APG Assists per game SPG Steals per game\\n BPG Blocks per game PPG Points per game Bold Career high\\nRegular season\\nYear Team GP GS MPG FG% 3P% FT% RPG APG SPG BPG PPG\\n1989–90 LA Lakers 82 5 19.6 .499 .000 .708 6.2 0.9 1.0 1.4 8.5\\n1990–91 LA Lakers 82 81 28.2 .565 .357 .703 8.1 1.1 1.3 1.5 11.2\\n1991–92 LA Lakers 36 18 27.2 .495 .263 .768 6.9 1.7 1.5 1.0 11.3\\n1992–93 LA Lakers 82 69 30.8 .485 .280 .689 8.9 2.8 1.6 1.7 12.8\\n1993–94 LA Lakers 79 73 34.0 .506 .191 .686 10.8 3.9 1.2 1.4 14.2\\n1994–95 LA Lakers 80 80 35.1 .507 .185 .777 10.4 4.1 1.4 2.2 16.0\\n1995–96 LA Lakers 79 79 31.3 .513 .167 .641 8.6 3.3 1.0 1.7 12.9\\n1996–97 Charlotte 81 80 35.1 .494 .234 .683 9.0 3.7 1.3 2.2 12.6\\n1997–98 Charlotte 64 41 28.2 .498 .214 .691 8.1 2.7 1.3 1.5 10.4\\n1998–99 Sacramento 50 50 35.2 .470 .256 .702 10.0 4.3 0.9 1.0 14.3\\n1999–2000 Sacramento 82 81 29.0 .503 .269 .691 8.0 3.0 1.3 1.3 12.3\\n2000–01 Sacramento 81 81 29.9 .482 .286 .691 8.3 2.9 1.1 1.1 12.0\\n2001–02 Sacramento 80 80 30.3 .472 .231 .615 8.4 3.7 1.0 1.2 11.1\\n2002–03 Sacramento 80 80 29.8 .466 .240 .713 7.2 3.4 1.0 1.3 9.9\\n2003–04 Sacramento 81 81 28.6 .470 .154 .654 5.7 5.3 0.7 0.1 9.9\\n2004–05 LA Lakers 15 0 8.7 .419 .000 .667 2.1 1.3 0.3 0.1 2.3\\nCareer 1134 979 29.8 .495 .235 .692 8.2 3.1 1.1 1.4 11.8\\nAll-Star 1 0 9.0 .667 .000 – 6.0 1.0 2.0 0.0 8.0\\nPlayoffs\\nYear Team GP GS MPG FG% 3P% FT% RPG APG SPG BPG PPG\\n1990 LA Lakers 9 1 19.4 .727 .500 .895 5.3 1.1 0.9 1.7 9.1\\n1991 LA Lakers 19 19 32.1 .564 .167 .803 6.7 1.1 1.4 2.2 13.3\\n1992 LA Lakers 4 4 35.8 .349 .000 .900 5.5 3.8 1.3 0.8 9.8\\n1993 LA Lakers 5 5 33.4 .500 .444 .545 9.4 5.6 1.2 2.4 18.0\\n1995 LA Lakers 10 10 38.8 .467 .222 .645 8.5 3.1 0.8 1.3 15.6\\n1996 LA Lakers 4 4 28.8 .429 .200 .625 7.5 2.0 0.0 1.3 9.0\\n1997 Charlotte 3 3 38.7 .457 .000 .800 8.7 3.3 1.0 2.0 18.0\\n1998 Charlotte 9 9 38.5 .483 .000 .606 10.9 3.4 0.8 1.6 11.6\\n1999 Sacramento 5 5 39.6 .446 .200 .833 10.0 4.6 1.6 0.8 16.2\\n2000 Sacramento 5 5 32.0 .357 .000 .696 7.2 2.8 1.4 0.8 11.2\\n2001 Sacramento 8 8 28.1 .350 .333 .763 8.4 2.4 1.0 1.5 10.8\\n2002 Sacramento 16 16 33.4 .464 .268 .755 9.3 1.7 1.1 1.3 13.5\\n2003 Sacramento 12 12 26.4 .560 .000 .673 5.8 2.3 0.7 0.9 11.4\\n2004 Sacramento 12 12 19.6 .437 .000 .739 4.9 1.8 0.3 0.4 6.6\\nCareer 121 113 30.8 .480 .241 .731 7.5 2.4 1.0 1.4 12.1\\nMajor career achievements\\nKK Partizan\\nYugoslav League Champion: (1987)\\n1988 EuroLeague Final Four: 3rd Place\\nYugoslav Cup Winner: (1989)\\nKorać Cup Winner: (1989)\\nYugoslavia national team\\nEarned gold medal with Yugoslavia''s under-18 nationals at the 1985 FIBA Europe Under-16 Championship in Rousse, Bulgaria\\nEarned gold medal with Yugoslavia''s under-21 nationals at the 1986 FIBA Europe Under-18 Championship in Gmunden, Austria\\nEarned gold medal with Yugoslavia''s under-21 nationals at the 1987 FIBA Under-19 World Cup in Bormio, Italy, defeating the U.S. team twice in that tournament\\nEarned silver medals in 1988 Summer Olympic Games (for SFR Yugoslavia) and 1996 Summer Olympic Games (for FR Yugoslavia)\\nEarned gold medals with SFRY at the 1990 FIBA World Championship (Argentina) and with FRY at the 2002 FIBA World Championship (U.S.)\\nEarned gold medals at EuroBasket in Zagreb 1989, and Rome 1991 (with SFRY), and in Athens 1995 (with FRY)\\nNBA\\nNamed to the 1989–90 NBA All-Rookie First Team after averaging 8.5 ppg and 6.2 rpg for the Lakers\\nAppeared in the 1991 NBA Finals against the Chicago Bulls and averaged 12.1 ppg, 7.5 rpg and 2.4 apg in 121 career NBA Playoff games\\nRanks 4th in Lakers franchise history with 830 blocked shots\\nRanked 2nd on the Kings in scoring (14.3 ppg), rebounds (10.0 rpg, 10th in the NBA), assists (4.3 apg) and blocked shots (1.02 bpg) in 1998–99\\nNamed NBA All-Star, 2001\\nOne of only five basketball players born and trained in Europe to play at least 1,000 NBA games (1,134; along with Dirk Nowitzki, Tony Parker, Pau Gasol, Boris Diaw)\\nOne of only four basketball players born and trained in Europe (Peja Stojaković, Dražen Petrović and Zydrunas Ilgauskas are the others) to have his number retired by an NBA team\\nAdministrative career\\nThrough the twilight of his playing career and afterwards, Divac focused on three fields: humanitarian work, sport management, and investment.\\nKK Partizan president\\nIn late 2000, following the overthrow of Slobodan Milošević whose policies Divac had been openly critical of throughout mid-to-late 1990s,[31] Divac and former teammate Predrag Danilović took over their former club KK Partizan. They did so on initiative by Ivica Dačić, the club''s outgoing president and, more importantly, a suddenly marginalized politician who, due to his association with Milošević, was forced to leave his post at the club. Seeing that various state-owned companies and community property were being taken over in a dubious manner during the power vacuum that resulted from régime change, Dačić saw it prudent to bring the club''s two former greats as a safeguard against the same happening to KK Partizan. Divac became the club''s president while Danilović took the vice-president role.[32]\\nFreshly retired from playing, Danilović was actually running the club''s day-to-day operations since Divac was still very actively involved with the Sacramento Kings at the time. The head coach they inherited, Darko Russo, finished out the 2000–01 season before they decided in summer 2001 to bring back their mentor Duško Vujošević to be the new head coach.\\nThough the duo never stated so outright, their additional motivation in getting involved with KK Partizan again was perceived to be gaining the upper hand on the club''s eventual privatisation process once the new Law on Sports was passed in the Serbian parliament. Since the exact ownership structure of a publicly owned KK Partizan was not and still is not really clear, potential investors decided to stay away, at least until the law came into effect. Divac and Danilović appeared pretty much out of nowhere in this regard but enjoyed plenty of fan and public support because most preferred to see their beloved club owned and operated by its former stars rather than a faceless corporation or a group of politicians, managers or businessmen close to the ruling coalition. However, after a few years the duo ran out of patience and pulled out of the venture in late 2004 because it became too much of a financial burden with no end goal in sight. While he stopped performing any official functions at the club, Divac continued to be involved with it in a lesser capacity for a few years afterwards.\\nLA Lakers scout\\nIn October 2005, right after ending his playing career with the Los Angeles Lakers, Divac got hired as the Lakers'' European scout, reporting directly to the team''s general manager Mitch Kupchak.[33] He left the position in 2006.\\nReal Madrid Baloncesto club management\\nIn June 2006, through his friendship with Predrag Mijatović, Divac linked up with Ramón Calderón as part of the lawyer''s candidate bid for the presidency of Real Madrid polideportivo.[34] When Calderón closely won the club elections on July 2, 2006, Divac was announced as the head of operations at Real Madrid basketball club though the scope of his job description soon got reduced to consulting duties as president Calderón''s adviser for basketball and club''s international coordinator.[35][36]\\nHowever, Divac''s role in the club''s day-to-day operations turned out to be largely symbolic, and he even admitted as much in a March 2007 interview for Croatian weekly Globus: \"I literally do nothing and I only serve as part of the royal club''s image. I only accepted the job because of Mijatović, who is currently the football director at Real\".[37] By the end of 2007, following a financial settlement between the two parties, Divac moved on from the post for which he had been reportedly receiving an annual compensation of €300,000.[35][38]\\nSerbian Deputy Prime Minister''s adviser\\nIn October 2008, Divac''s political advisory engagement within the Serbian government as the sports, diaspora, and humanitarian advisor to the Deputy Prime Minister and Internal Affairs Minister Ivica Dačić, got announced.[39][40][41]\\nOlympic Committee of Serbia president\\nDivac was proposed in 2000 as Yugoslavia''s candidate for the Sport Commission of the International Olympic Committee in spring 2000. This candidature was withdrawn under pressure from Milošević regime.[42] In February 2009, Divac ran for presidency of the Olympic Committee of Serbia against incumbent president Ivan Ćurković.[43] He won the race after Ćurković withdrew just before the scheduled voting.[8] In November 2012, he was re-elected as the sole candidate; the end of his second mandate coincides with the 2016 Summer Olympics in Rio de Janeiro.[9]\\nIn December 2014, Kosovo was accepted as a full member of the International Olympic Committee. Divac and the Serbian Olympic Committee have been criticised, chiefly by the Democratic Party of Serbia, for failing to take any effort to prevent that.[44] Divac stated that he is not happy with the decision of the IOC, but could not have prevented it as it had already been made, and said he would accept it \"in the interest of the athletes\".[45]\\nOn May 9, 2017, he was succeeded by Serbian former basketball coach Božidar Maljković on position of the president of Olympic Committee of Serbia.[46]\\nSacramento Kings front office\\nInitial advisory role\\nIn early March 2015, Divac was hired by the Sacramento Kings as their vice president of basketball and franchise operations.[47] Brought into the organization by the principal owner Vivek Ranadivé towards the end of a turbulent season, Divac''s arrival came in the wake of head coach Mike Malone''s firing and the eventual hiring of George Karl. Working alongside the team''s general manager Pete D''Alessandro, Divac''s initial duties with the Kings were reported to be advising the front office and coaches as well as assisting with branding and fan outreach.[47] However, such broadly defined job responsibilities immediately led to press speculation about Divac''s role within the organization that in addition to general manager D''Alessandro also featured assistant GM Mike Bratz, special assistant to the GM Mitch Richmond, director of player personnel and analytics Dean Oliver, adviser to the chairman Chris Mullin, as well as a head coach, Karl, who has always wanted to be involved in personnel issues.[48] Within a month of Divac''s hiring, ESPN''s Marc Stein reported that \"despite the Kings not yet announcing their new power structure, Divac is indeed already regarded as the team''s top basketball official by owner Ranadivé\".[49]\\nOn June 10, 2015, two weeks before the NBA draft, general manager D''Alessandro left the Kings by accepting a front-office position with the Denver Nuggets amid reports he did so due to being stripped of his decision-making power after Ranadivé hired Divac.[50][51]\\nOnly days before the draft, animosity between head coach Karl and the team''s star center DeMarcus Cousins reignited, as Karl reportedly lobbied Divac, as well as multiple players on the Kings'' roster, in order to make the case to owner Ranadive that Cousins needs to be traded.[52] As a result, against the backdrop of Cousins calling Karl a \"snake\" on Twitter,[53] Divac reportedly discussed multiple Cousins trade scenarios with various teams, but ultimately no deal got made.[54] At the 2015 NBA draft, with the 6th pick, the Kings selected 21-year-old center Willie Cauley-Stein out of Kentucky. Less than a week following the draft, with the dissolution of the Karl—Cousins relationship on public display, the Kings'' ultimately unsuccessful attempt at landing University of Kentucky head coach John Calipari to replace Karl was reported.[55]\\nIn early July 2015, in an effort of clearing salary cap space in order to immediately go after free agents, the Kings agreed to a trade with the Philadelphia 76ers, sending Nik Stauskas, Carl Landry, and Jason Thompson, along with the Kings'' future first round draft pick to the Sixers as well as the rights to swap first round picks in 2016 and 2017 while receiving the rights to Sixers overseas players Artūras Gudaitis and Luka Mitrović in return.[56] Two days later, they announced the acquisitions of two free agents: 29-year-old Marco Belinelli on a three-year US$19 million contract and 29-year-old point guard Rajon Rondo for one year for US$10 million.[57] This was followed by signing twenty-six-year-old center Kosta Koufos for four years and US$33 million with his role envisioned as the backup for Cousins.[58]\\nWith the free agent signings done, Divac turned his attention to attempting to mend the relations between the team''s head coach Karl and its star center Cousins ahead of the 2015-16 season, admitting publicly on July 9, 2015 on CBS Sports Radio''s The Jim Rome Show that the relationship between the two \"isn''t pretty right now\".[59] A few days later, on July 13, 2015, during a 2015 NBA Summer League game in Las Vegas, the two shared an awkward on-camera handshake as Karl approached and Cousins reluctantly shook the coach''s hand before turning away.[60][61] Later that week, Divac summoned Cousins and Karl to a private counseling session.[61]\\nGeneral manager\\nDivac was promoted to the Kings'' vice president of basketball operations and general manager on August 31, 2015.[62]\\nAmid a tense[63] and incident-filled[64] season that saw the team briefly reach the final playoff spot in the Western Conference before unravelling with extended losing streaks in late January and early February 2016, the organization reportedly made a decision to fire their head coach George Karl during the upcoming All-Star break, a move pushed for by Divac.[65] However, in a quick about-face, Karl got retained after meeting with Divac and reportedly pledging to make changes to address concerns within the organization about his defensive schemes and practice policies.[66] It was later reported that the move to fire Karl on this occasion got scuttled by the Kings minority owners over financial concerns.[67] A month and a half later, in late March 2016, Divac signed a multi-year contract extension with the organization.[68] The team finished the season 33–49, eight games out of the playoffs, good for 10th spot in the Western Conference. Their final season in Sleep Train Arena, the team''s home since 1988, it was also their first 30 plus win campaign after seven consecutive seasons of fewer than 30 wins.\\nEarly into the team''s offseason, in mid April 2016, the Kings organization fired head coach Karl, a decision made by Divac who had reportedly been pushing for it for months.[67] Within three weeks, during which Divac interviewed head coaching candidates Sam Mitchell, Vinny Del Negro, Mike Woodson, David Blatt, Mark Jackson, Jeff Hornacek, Nate McMillan, Patrick Ewing, Elston Turner, and Corliss Williamson,[69] the Kings hired Dave Joerger as their new head coach, signing him to a four-year deal worth US$16 million.[69] At the 2016 NBA draft, with the 8th pick, the Kings selected Marquese Chriss out of the University of Washington, but traded him to the Phoenix Suns for rights to Bogdan Bogdanović as well as the Suns'' 2016 draft 13th and 28th picks, Georgios Papagiannis and Skal Labissière, respectively.\\nAt the 2017 NBA draft, with the 5th pick, the Kings selected point guard De''Aaron Fox out of Kentucky. At the 2018 NBA draft, the Kings selected Marvin Bagley III with the second overall pick, passing on Luka Dončić who would become a MVP candidate within two years into his NBA career.[70] In 2018–19 season the Sacramento Kings finished 9th in the Western conference. However, the season was evaluated as successful for the Kings.[71]\\nThe 2019–20 NBA season was suspended in March as a result of the COVID-19 pandemic, and the Sacramento Kings were invited to the 22-team 2020 NBA Bubble. However, the Kings did not manage to qualify for the playoffs, their 14th consecutive season without a playoff appearance, and finished the season with a 31–41 record. Shortly thereafter, on August 14, 2020, Divac stepped down as general manager.[72]\\nInvestments\\nDivac has been involved in many non-basketball endeavors while still actively playing in the NBA, and more so after he retired. He is an active restaurant investor in the Sacramento, California area. However, his attempts to make major investments in Serbia failed, for a variety of reasons.\\nThe most notable affair was a highly publicized business venture—takeover bid of profitable beverage producer Knjaz Miloš. Divac''s company \"Apurna\", in a joint venture with French dairy giant Danone, ostensibly proposed the best bid, but the takeover was aborted by the Serbia''s Securities Commission, because Danone\/Apurna allegedly offered extra money to small shareholders.[73] In the repeated bid, Divac and Danone eventually withdrew and the sale went to FPP Balkan Ltd., a privatization fund from the Cayman Islands. The entire messy affair caused great friction within the Serbian government, wide speculation about corruption, resignation of the Securities Commission chief, and even a police investigation.[74]\\nAnother similar, though less spectacular, episode happened with 2005 Divac''s attempt to take over the Večernje novosti, a Serbian high-circulation daily.[75] He made an agreement with small shareholders to take over the company by means of registering a new company with joint capital, which would increase the share capital. However, the Serbian Government intervened and halted what should have been a mere technical move. While the attempted takeover was a \"backdoor\" one indeed, it was legal and similar cases had already occurred. The government ostensibly feared lack of control over the influential daily. Even though the Supreme Court of Serbia eventually ruled in Divac''s favor, he withdrew from the contest, citing \"friendly advice\" by unnamed persons.[76] Embittered, he decided to stop his attempts to invest in Serbia: \"All of this is ugly and I''m very upset... I realized that there''s no place for me in Serbia and my friends can meet me in Madrid from now on... In Serbia, some different rules are in effect, and I can''t conceive them\".[77]\\nHowever, that turned out not to be true, as in October 2007 Divac got legally registered as the 100% owner of Voda Voda, a bottled water brand previously owned by businessman Vojin Đorđević. That transaction was also followed by a stir of controversy, as Đorđević publicly accused Divac of deceit, asserting that he broke a gentlemen''s agreement they had, and questioning the validity of the contract that Divac presented to the Serbian Business Registers Agency. The circumstances surrounding the deal (as of November 2007) are still unclear: Divac claims that he indeed loaned some money to Đorđević''s Si&Si company, which was in financial trouble, and after Đorđević failed to fulfill his part of the deal, just used the contract, already properly signed by Đorđević, to claim ownership of the company.[78][79]\\nHumanitarian work\\nVlade Divac (rear, center) alongside Crown Prince Alexander II in 2005, at an event for World Heart Day\\nDivac is a humanitarian worker, focusing on aid to children worldwide and refugees in his home country. Along with six Serbian basketball teammates, Divac established the charity called Group Seven, later renamed to \"Divac''s Children Foundation\", and works closely with International Orthodox Christian Charities (IOCC), helping them to raise around US$500,000 for humanitarian assistance in Serbia since 1997.[80] Divac''s own foundation, presided by his wife Snežana, provided over $2,500,000 in humanitarian assistance through 1998–2007.[81]\\nIn late 2007 Divac founded a humanitarian organization, \"You Can Too\" (Serbian: Можеш и ти\/Možeš i ti), bent on assisting the refugees in Serbia. Serbia has around 500,000 refugees from the 1990s Yugoslav wars, making it the country with the largest refugee problem in Europe.[81] Around 7,800 of those people still live in collective centers under poor conditions, so the organization has employed itself to buy abandoned countryside houses, in an attempt to finally solve their accommodation problem.[82]\\nFrom September 21 to 23, 2007, Divac organized an official farewell from his active basketball career in his hometown Prijepolje and Belgrade, simultaneously promoting the \"You Can Too\" campaign. The spectacle culminated in a gathering of Divac and his worldwide friends in front of 10,000 people outside the National Assembly building.[83]\\nIn popular culture\\nIn the early 1990s, the song \"Vlade Divac\" by Belgrade band Deca Loših Muzičara, devoted to his move to the Lakers, was a big hit; the band finally got to personally meet Divac and perform the song with him on his farewell party in 2007.[84]\\nDuring his time with the Lakers, Divac''s popularity and marketing potential, in addition to his entertaining and good-natured personality, were picked up on by the American TV industry. As a result, he appeared quite a few times on Los Angeles-based late night programmes such as The Arsenio Hall Show and The Tonight Show with Jay Leno. In 1990, he was featured in a commercial with Laker teammates A. C. Green and Mychal Thompson for the Schick brand razor company.[85] He also appeared in American sitcoms Married... with Children and Coach, as well as in the short lived Good Sports sitcom. On the big screen Divac took part in basketball-based movies Eddie, Space Jam and Juwanna Mann. Later in his career, he appeared on Larry King Live in 1999 and The Late Late Show in 2002.\\nIn Serbia, throughout his playing career, Divac regularlyyyyyyyyy"
  }';
  -- replace tabs with \\t, replace carriage return with \\n
  SELECT ISJSON(@json);
  /*
  SELECT JSON_VALUE(@json, '$.Name');
  
  SELECT JSON_VALUE(@json, '$.Surname');
  
  SELECT JSON_VALUE(@json, '$.Born.DoB');
  
  SELECT JSON_VALUE(@json, '$.Born.Country');
  
  SELECT JSON_VALUE(@json, '$.Career[2].period.start');
  
  SELECT JSON_VALUE(@json, '$."NBA Stat".rebounds');
  
  --SELECT JSON_VALUE(@json, 'strict $.name');
  
  SELECT JSON_VALUE(@json, '$.Bio');
  
  SELECT JSON_QUERY(@json, '$.Born');
  
  SELECT JSON_QUERY(@json, '$.Teams');
  
  SELECT JSON_QUERY(@json, '$.Name');
  
  SELECT JSON_MODIFY(@json, '$.Bio', 'Vlade Divac is a Serbian professional basketball executive and former player who was most recently the vice president');
  
  SELECT JSON_MODIFY(@json, 'append $.Teams', 'Charlotte Hornets');
  
  SELECT JSON_MODIFY(@json, '$.Born', '{"DoB": "1968-03-02", "Town": "Prijepolje"}');
  
  SELECT JSON_MODIFY(@json, '$.Born', JSON_QUERY('{"DoB": "1968-03-02", "Town": "Prijepolje"}'));
  
  SELECT *
  FROM OPENJSON(@json);
  
  SELECT *
  FROM OPENJSON(@json, '$.Born');
  
  SELECT *
  FROM OPENJSON(@json, '$.Teams');
  
  SELECT JSON_VALUE(@json, '$.Bio');
  
  SELECT value FROM OPENJSON(@json) WHERE [key] = 'Bio';
  
  SELECT Bio FROM OPENJSON(@json) WITH (Bio NVARCHAR(MAX));
  
  SELECT *
  FROM OPENJSON(@json, '$.Born')
  WITH (DoB DATETIME, Town NVARCHAR(50), Country NVARCHAR(50));
  
  SELECT *
  FROM OPENJSON(@json, '$.Career')
  WITH (team NVARCHAR(50), gp INT, gs INT)
  
  SELECT *
  FROM OPENJSON(@json, '$.Career')
  WITH (team NVARCHAR(50), gp INT, gs INT, StartYear INT '$.period.start', EndYear INT '$.period.end');
  
  SELECT *
  FROM OPENJSON(@json, '$.Career')
  WITH (team NVARCHAR(50), gp INT, gs INT, [period] NVARCHAR(MAX) AS JSON);
  
  SELECT 1 AS x
  , 2 AS y
  , 3 AS z
  , NULL AS nothing
  FOR JSON PATH;
  
  SELECT 1 AS "point.x"
  , 2 AS "point.y"
  , 3 AS z
  FOR JSON PATH;
  
  ;WITH src(x,y)
  AS
  (
  SELECT 1 AS x
  , 2 AS y
  UNION
  SELECT 3 AS x
  , 4 AS y
  )
  SELECT *
  FROM src
  FOR JSON PATH;
  
  SELECT 1 AS x
  , 2 AS y
  , 3 AS z
  FOR JSON PATH, WITHOUT_ARRAY_WRAPPER;
  
  ;WITH src(x,y)
  AS
  (
  SELECT 1 AS x
  , 2 AS y
  UNION
  SELECT 3 AS x
  , 4 AS y
  )
  SELECT *
  FROM src
  FOR JSON PATH, WITHOUT_ARRAY_WRAPPER;
  
  SELECT 1 AS x
  , 2 AS y
  , 3 AS z
  FOR JSON PATH, ROOT('object');
  */
  SELECT 1 AS x
  , 2 AS y
  , 3 AS z
  , '{"x":1, "y":2}' AS something
  , JSON_QUERY('{"x":1, "y":2}') AS JSON
  FOR JSON PATH;