Sql Server – Split Column With Delimited String Into Multiple Columns

Method 1: To Split A Column With Delimited String Into Multiple Columns more...

Method 2: SELECT
                       PARSENAME(REPLACE ('John,Doe', ',', '.'), 2) 'First Name',
                       PARSENAME(REPLACE ('John,Doe', ',', '.'), 1) 'Last Name'

Run Python with T-SQL on SSMS

1. Run the following commands in SSMS:
    sp_configure 'external scripts enabled'
    GO
    sp_configure 'external scripts enabled', 1;
    GO
    RECONFIGURE;
    GO
    sp_configure 'external scripts enabled'
    GO

2. Restart the SQL Server Service

3. Run the following command in SSMS:
    sp_configure 'external scripts enabled'
    GO

4. Test the code:
    EXEC sp_execute_external_script
    @language = N'Python',
    @script = N'print(''Hello Python !!! from T-SQL'')'

More...

Python Clear the Interpreter Console

import os
clear = lambda: os.system('cls')
clear()

SQL Key-Value Paired Join

SELECT * FROM Tabe1 u
JOIN (
(123, 'peter6@gmail.com', 3),
(555, 'jbrown@gmail.com', 4),
(946, 'jdoe12@gmail.com', 1)
) v(EmployeeId, Email, Department)
ON (
v.Email = u.Email
and v.EmployeeId = u.EmployeeId
)

JS Productivity Tools

https://popper.js.org/
http://marak.github.io/faker.js/
https://pushjs.org/
https://scotch.io/tutorials/json-server-as-a-fake-rest-api-in-frontend-development

Enabling Non-Null Reference Types in VS Code

Add two new properties to any PropertyGroup: LangVersion and Nullable:   <PropertyGroup>         <LangVersion>8.0</LangVersion>     <Nullable>enable</Nullable>    </PropertyGroup> Enable the annotation for nullable reference types #nullable enable string? name = null;

Getting API Data using XMLHttpRequest

<button id='get-btn' onclick='getData()'>GET</button> const getBtn = document.getElementById('get-btn'); const getData = () => {   const xhr = new XMLHttpRequest();   xhr.open('GET', 'https://reqres.in/api/users/');   xhr.responseType = 'json';   xhr.onload  = () => {     console.log(xhr.response);   }   xhr.send();   } getBtn.addEventListener('click', getData);