MS SQL script to create database and add data

This Microsoft SQL script was used to create a database table named colbert_stateFacts with fields stID, state_name, state_capital, state_code, state_bird and state_flower. The script then inserted records into the new table. CREATE TABLE [dbo].[colbert_stateFacts] ( [stID] [int] IDENTITY(1,1) NOT NULL, [state_name] [nvarchar](50) NOT NULL, [state_capital] [nvarchar](50) NOT NULL, [state_code] [nvarchar](2) NOT NULL, [state_bird] [nvarchar](50) NULL, … Read more MS SQL script to create database and add data

Add A New Worksheet Using Excel VBA

Add a new worksheet named “Mike”… Worksheets.Add.Name = “Mike” Add a new worksheet named “Mike” as the first worksheet, before all the other worksheet tabs… Worksheets.Add(Before:=Worksheets(1).Name = “Mike” Add a new worksheet named “Mike” as the last worksheet, after all the other worksheet tabs… Worksheets.Add(Before:=Worksheets(Worksheets.Count).Name = “Mike”

Markdown Code Block Sample

Test to see if Markdown works: Some text before the code block. <%@ Page Title=”” Language=”VB” MasterPageFile=”~/msci3025.master” AutoEventWireup=”false” CodeFile=”ThankYou.aspx.vb” Inherits=”ThankYou” %> <asp:Content ID=”Content1″ ContentPlaceHolderID=”head” Runat=”Server”> </asp:Content> <asp:Content ID=”Content2″ ContentPlaceHolderID=”ContentPlaceHolder1″ Runat=”Server”> Thank you for participating in our survey! </asp:Content> Some text after the code block.

Using Markdown to display code blocks in WordPress

Download and install the JP Markdown plugin for WordPress. This is just the Markdown functionality from JetPack. I couldn’t get JetPack working on this installation of WordPress because access is denied to XML-RPC. After the JP Markdown plugin is installed and activated, you can insert blocks of code using three backticks to demarc the start … Read more Using Markdown to display code blocks in WordPress