karenpayneoregon

DECLARE @OrderIdentifier INT= 10248;
SELECT p.ProductName, 
       od.ProductID, 
       od.UnitPrice, 
       od.Quantity, 
       od.Discount
FROM OrderDetails AS od
     INNER JOIN Products AS p ON od.ProductID = p.ProductID
WHERE od.OrderID = @OrderIdentifier;

karenpayneoregon

DECLARE @CategoryID INT= 2;
SELECT P.ProductID, 
       P.ProductName, 
       P.UnitPrice, 
       P.UnitsInStock, 
       P.SupplierID, 
       S.CompanyName AS SupplierName, 
       C.[Name] AS SupplierCountry
FROM Products AS P
     INNER JOIN Suppliers AS S ON P.SupplierID = S.SupplierID

karenpayneoregon

SELECT E.EmployeeID, 
       E.TitleOfCourtesy, 
       E.LastName, 
       E.FirstName, 
       CT.ContactTitle, 
       CONVERT(VARCHAR, E.BirthDate, 1) AS BirthDate, 
       CONVERT(VARCHAR, E.HireDate, 1) AS HireDate, 
       E.Address AS Street, 
       E.City, 
       E.Region, 

karenpayneoregon

using System;
using System.IO;
using System.Reflection;

namespace ApplicationShortCut
{
    public class ApplicationServices
    {
        private static readonly string DesktopFolder = 
            Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);

karenpayneoregon

Public Class Form1
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        ListBox1.DisplayMember = "Name"
        ListBox1.DataSource = ResourceImages.GetInstance().BitMaps()
    End Sub
    Private Sub GetImageButton_Click(sender As Object, e As EventArgs) Handles GetImageButton.Click
        PictureBox1.Image = ResourceImages.GetInstance().GetSingleBitMap(ListBox1.Text)
    End Sub
End Class

karenpayneoregon

using System.Text.RegularExpressions;

namespace Validators
{
    public static class ValidateExtensions
    {

        /// <summary>
        /// Validate
        ///   Don't allow "219-09-999" or "078-05-1120" explicitly

karenpayneoregon

{
	"document ready empty": {
		"prefix": "dre",
		"body": [
		  "<script>",
		  "    $(document).ready(function() {",
		  "        ${0:}",
		  "    });",
		  "</script>"
		],

karenpayneoregon

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace DescendantsLibrary
{
    public static class ControlExtensions

karenpayneoregon

USE [master]
GO
/****** Object:  Database [NorthWind2020]    Script Date: 7/20/2021 10:25:30 AM ******/
CREATE DATABASE [NorthWind2020]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'NorthWind2020', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\NorthWind2020.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'NorthWind2020_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\NorthWind2020_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO

karenpayneoregon

using System.Drawing;
using System.IO;

namespace UtilityLibrary
{
    /// <summary>
    /// 
    /// </summary>
    /// <remarks>
    /// Requires NuGet package