Carl Cook carlcom

## nice_mssql_email.sql
/*************************************************************************************************

Created On 7/23/2015
Created By CCook

Description: Email ...

Modified by		Date		Reason for Modification
-------------	----------	----------------------------------------

## xDoc.sql
CREATE PROCEDURE [dbo].[mySproc]
 @xDoc    XML
AS
/********************************************************************************************************
Created by:  Carl Cook

Purpose:  Show how to use a single XML input. Simplify debugging: no more copying many input values from
          your source to SSMS to exec the Sproc. A new input (in @xDoc) will be ignored, not cause a run time
          error, if the Sproc has not been updated. No SQL injection issues as @xDoc is converted to SQL params.
          Mix @xDoc with other inputs if wanted.

## my_page.html
<!doctype html>
<html>
<head>
 <title> Hi *you*! </title>
 <meta name="author" content="Carl Cook">
    <!-- Scratching the surface, just a starting point -->
</head>
<body>
    <h2><span id="salutation">Hi</span> *you*!</h2>
    <!-- colors with # and 3 or 6 digits (hexadecimal 0123456789abcdef) are RGB, Red Green and Blue, so try some combinations -->

## dntController.cs
using Microsoft.AspNetCore.Mvc;
using Hover.Models;

namespace Hover.Controllers
{
    [Route(".well-known/[controller]")]
    public class DntController : ControllerBase
    {
        private Settings Settings { get; set; }
        public DntController(Microsoft.Extensions.Options.IOptions<Settings> settings)
	/*************************************************************************************************

	Created On 7/23/2015
	Created By CCook

	Description: Email ...

	Modified by Date Reason for Modification
	------------- ---------- ----------------------------------------
	CREATE PROCEDURE [dbo].[mySproc]
	@xDoc XML
	AS
	/********************************************************************************************************
	Created by: Carl Cook

	Purpose: Show how to use a single XML input. Simplify debugging: no more copying many input values from
	your source to SSMS to exec the Sproc. A new input (in @xDoc) will be ignored, not cause a run time
	error, if the Sproc has not been updated. No SQL injection issues as @xDoc is converted to SQL params.
	Mix @xDoc with other inputs if wanted.
	<!doctype html>
	<html>
	<head>
	<title> Hi you! </title>
	<meta name="author" content="Carl Cook">
	<!-- Scratching the surface, just a starting point -->
	</head>
	<body>
	<h2><span id="salutation">Hi</span> you!</h2>
	<!-- colors with # and 3 or 6 digits (hexadecimal 0123456789abcdef) are RGB, Red Green and Blue, so try some combinations -->
	using Microsoft.AspNetCore.Mvc;
	using Hover.Models;

	namespace Hover.Controllers
	{
	[Route(".well-known/[controller]")]
	public class DntController : ControllerBase
	{
	private Settings Settings { get; set; }
	public DntController(Microsoft.Extensions.Options.IOptions<Settings> settings)