Skip to content

Instantly share code, notes, and snippets.

View JHarry444's full-sized avatar

JHarry JHarry444

164 followers · 3 following
View GitHub Profile
@JHarry444
JHarry444 / Module 1 - Table Expressions.sql
Last active December 9, 2022 16:35
-- VIEWS
USE Northwind
GO
CREATE VIEW dbo.ReportsTo AS (
SELECT
m.FirstName + ' ' + m.LastName AS ManagerName, e.FirstName + ' ' + e.LastName AS EmployeeName
FROM
dbo.Employees AS e
JOIN
dbo.Employees AS m
@JHarry444
JHarry444 / Module2.sql
Last active December 9, 2022 15:32
TSQL examples for Avanade
-- USE Northwind
-- comments out the query so it's not run
SELECT * FROM Northwind.dbo.Orders
SELECT * FROM dbo.Orders
SELECT * FROM Orders
SELECT CustomerID, OrderDate FROM Orders
SELECT OrderDate, CustomerID FROM Orders
@JHarry444
JHarry444 / Demo.java
Created September 15, 2020 09:22
package sdet;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.Optional;
import java.util.function.Predicate;
import java.util.stream.IntStream;
import java.util.stream.Stream;
@JHarry444
JHarry444 / App.java
Created July 3, 2020 12:03
public class App {
public static final Scanner scan = new Scanner(System.in);
public static void main(String[] args) {
System.out.println(flip(CoinFlip.HEADS));
boolean b = true;
while (b) {
try {
System.out.println("Enter a number:");
@JHarry444
JHarry444 / Optionals.java
Created June 23, 2020 09:35
package main;
import java.util.Optional;
public class Optionals {
public static void main(String[] args) {
// String isItNull = isItNull();
// if (isItNull != null) {
// System.out.println(isItNull.length());
@JHarry444
JHarry444 / make_element.js
Last active June 19, 2020 11:19
JS function that create an HTML Element and then sets its attributes.
function makeElement(eleType, appendTo, attributes) {
const element = document.createElement(eleType);
for (let attr in attributes) {
element[attr] = attributes[attr];
}
appendTo.appendChild(element);
return element;
}
@JHarry444
JHarry444 / details.html
Last active June 18, 2020 14:19
<html>
<head></head>
<body>
<div id="bigOutput"></div>
<script src="https://cdnjs.cloudflare.com/ajax/libs/axios/0.19.2/axios.js"></script>
<script src="./js/details.js"></script>
</body>
@JHarry444
JHarry444 / create.html
Created June 16, 2020 10:30
<html>
<head>
</head>
<body>
<h1>Create Element</h1>
<input id='text' />
@JHarry444
JHarry444 / counter.html
Created June 16, 2020 08:57
<html>
<head></head>
<body>
<input id="counter" value="0" type="number" />
<button id="plus5">+5</button>
<button id="plus1" onclick="increment();">+</button><button id="minus1" onclick="decrement();">-</button>
<button id="minus5">-5</button>
<p id="myP">flfkdjhgdghdjgdfgndfkjg</p>
@JHarry444
JHarry444 / index.css
Created June 15, 2020 11:41
h1 {
color: red;
}
h1.header {
color: green;
}
h1#home-heading {
color: yellow;