DCCoder90

using System;
using Microsoft.Owin.Hosting;

namespace SelfHosted{
  class Program{
    static void Main(string[] args){
      using (WebApp.Start("http://localhost:8080")){
        Console.WriteLine("Web Server is running.");
        Console.WriteLine("Press any key to quit.");
        Console.ReadLine();

DCCoder90

using System.Collections.Generic;
using System.Web.Http;

namespace SelfHosted{
  public class HelloController : ApiController{
    // GET api/hello
    public IEnumerable Get(){
      return new string[] { "Hello", "World" };
    }

DCCoder90

using System.Web.Http;
using Owin;

namespace SelfHosted{
  public class Startup{
    public void Configuration(IAppBuilder app){
      // Configure Web API for self-host.
      var config = new HttpConfiguration();
      config.Routes.MapHttpRoute(
        name: "DefaultApi",

DCCoder90

SET NOCOUNT ON
GO

DECLARE @table TABLE(
RowId INT PRIMARY KEY IDENTITY(1, 1),
ForeignKeyConstraintName NVARCHAR(200),
ForeignKeyConstraintTableSchema NVARCHAR(200),
ForeignKeyConstraintTableName NVARCHAR(200),
ForeignKeyConstraintColumnName NVARCHAR(200),
PrimaryKeyConstraintName NVARCHAR(200),

DCCoder90

SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%COLUMN NAME%'
ORDER BY    TableName
            ,ColumnName;

DCCoder90

SELECT blocked_query.session_id AS blocked_session_id,

blocking_query.session_id AS blocking_session_id,

sql_text.text AS blocked_text,

sql_btext.text AS blocking_text,

waits.wait_type AS blocking_resource

DCCoder90

create function dbo.getFullyQualifiedName(
 @objectid int
) returns sysname
begin

 declare @fqn sysname
 select
  @fqn = CONCAT(
   QUOTENAME(@@SERVERNAME), '.',
   QUOTENAME(DB_NAME()), '.',

DCCoder90

  var previousHeight, currentHeight=0;
  while(previousHeight !== currentHeight) {
    previousHeight = currentHeight;
    var currentHeight = yield nightmare.evaluate(function() {
      return document.body.scrollHeight;
    });
    yield nightmare.scrollTo(currentHeight, 0)
      .wait(3000);
  }

DCCoder90

using System;
using System.Collections.Generic;
using System.Text;

namespace Validation
{
    public class AddressComponent {
        public string long_name { get; set; }
        public string short_name { get; set; }
        public List<string> types { get; set; }

DCCoder90

		public static class Extensions{
			
			/**
		       * Rounds the supplied number to the nearest multiple of the parameter
		       * @param this int The number to round
		       * @param int The multiple to use
		       * @return int
		       * @static
		       * @extension
		       */