Built for Team Treehouse weekly forum contest.
A Pen by Samara Soucy on CodePen.
Built for Team Treehouse weekly forum contest.
A Pen by Samara Soucy on CodePen.
using Microsoft.Analytics.Interfaces; | |
using Microsoft.Analytics.Types.Sql; | |
using Microsoft.VisualBasic.FileIO; | |
using System; | |
using System.Collections.Generic; | |
using System.Data; | |
using System.Data.SqlClient; | |
using System.IO; | |
using System.Linq; | |
using System.Text; |
[SqlUserDefinedOutputter] | |
public class ExternalDatabase : IOutputter | |
{ | |
private static string ConnectionString = "YOUR CONNECTION STRING"; | |
public override void Output(IRow row, IUnstructuredWriter output) | |
{ | |
using (System.Data.SqlClient.SqlConnection sqlConnection1 = | |
new System.Data.SqlClient.SqlConnection(ConnectionString)) |
//nothing special here, I just got tired of digging this up from MSDN | |
CREATE EXTERNAL TABLE [dbo].[all_dm_exec_requests]( | |
[session_id] smallint NOT NULL, | |
[request_id] int NOT NULL, | |
[start_time] datetime NOT NULL, | |
[status] nvarchar(30) NOT NULL, | |
[command] nvarchar(32) NOT NULL, | |
[sql_handle] varbinary(64), | |
[statement_start_offset] int, |
/****** Object: StoredProcedure [dbo].[sp_Get_Product_Temps] Script Date: 6/12/2018 1:13:12 PM ******/ | |
SET ANSI_NULLS ON | |
GO | |
SET QUOTED_IDENTIFIER ON | |
GO | |
-- ============================================= | |
-- Author: Samara Duncan | |
-- Create date: June 12, 2018 |
// Original JavaScript code by Chirp Internet: chirpinternet.eu | |
// Please acknowledge use of this code by including this header. | |
class MazeBuilder { | |
constructor(width, height) { | |
this.width = width; | |
this.height = height; |