Skip to content

Instantly share code, notes, and snippets.

@ConstantineK
Created March 7, 2019 20:53
Show Gist options
  • Save ConstantineK/55e8c83e059e86b39962b31097dcce00 to your computer and use it in GitHub Desktop.
Save ConstantineK/55e8c83e059e86b39962b31097dcce00 to your computer and use it in GitHub Desktop.
my first example tsql notebook in Azure Data Studio
Display the source blob
Display the rendered blob
Raw
{
"metadata": {
"kernelspec": {
"name": "SQL",
"display_name": "SQL",
"language": "sql"
},
"language_info": {
"name": "sql",
"version": ""
}
},
"nbformat_minor": 2,
"nbformat": 4,
"cells": [
{
"cell_type": "code",
"source": "SELECT \r\n TOP 10 \r\n o.name,\r\n o.object_id\r\nFROM sys.objects AS o \r\n\r\nSELECT\r\n min(m.number) smallest_number, \r\n max(m.number) biggest_number, \r\n COUNT(*) total_rows\r\nFROM master..spt_values AS m",
"metadata": {},
"outputs": [
{
"output_type": "display_data",
"data": {
"text/html": "Commands completed successfully."
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"text/html": "Total execution time: 00:00:00.0086034"
},
"metadata": {}
},
{
"output_type": "execute_result",
"execution_count": 5,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "name"
},
{
"name": "object_id"
}
]
},
"data": [
{
"0": "sysrscols",
"1": "3"
},
{
"0": "sysrowsets",
"1": "5"
},
{
"0": "sysclones",
"1": "6"
},
{
"0": "sysallocunits",
"1": "7"
},
{
"0": "sysfiles1",
"1": "8"
},
{
"0": "sysseobjvalues",
"1": "9"
},
{
"0": "sysmatrixages",
"1": "16"
},
{
"0": "syspriorities",
"1": "17"
},
{
"0": "sysdbfrag",
"1": "18"
},
{
"0": "sysfgfrag",
"1": "19"
}
]
},
"text/html": "<table><tr><th>name</th><th>object_id</th></tr><tr><td>sysrscols</td><td>3</td></tr><tr><td>sysrowsets</td><td>5</td></tr><tr><td>sysclones</td><td>6</td></tr><tr><td>sysallocunits</td><td>7</td></tr><tr><td>sysfiles1</td><td>8</td></tr><tr><td>sysseobjvalues</td><td>9</td></tr><tr><td>sysmatrixages</td><td>16</td></tr><tr><td>syspriorities</td><td>17</td></tr><tr><td>sysdbfrag</td><td>18</td></tr><tr><td>sysfgfrag</td><td>19</td></tr></table>"
},
"metadata": {}
},
{
"output_type": "execute_result",
"execution_count": 5,
"data": {
"application/vnd.dataresource+json": {
"schema": {
"fields": [
{
"name": "smallest_number"
},
{
"name": "biggest_number"
},
{
"name": "total_rows"
}
]
},
"data": [
{
"0": "-32768",
"1": "1469283328",
"2": "2540"
}
]
},
"text/html": "<table><tr><th>smallest_number</th><th>biggest_number</th><th>total_rows</th></tr><tr><td>-32768</td><td>1469283328</td><td>2540</td></tr></table>"
},
"metadata": {}
}
],
"execution_count": 5
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment