Built for Team Treehouse weekly forum contest.
A Pen by Samara Soucy on CodePen.
| // 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; |
| /****** 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 |
| //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, |
| [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)) |
| 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; |
Built for Team Treehouse weekly forum contest.
A Pen by Samara Soucy on CodePen.