PChemGuy pchemguy

layout	default
author	mattmc3
title	Modern SQL Style Guide
revision	2019-01-17
version	1.0.1
description	A guide to writing clean, clear, and consistent SQL.

Modern SQL Style Guide

People

`:bowtie:`	😄 `:smile:`	😆 `:laughing:`
😊 `:blush:`	😃 `:smiley:`	☺️ `:relaxed:`
😏 `:smirk:`	😍 `:heart_eyes:`	😘 `:kissing_heart:`
😚 `:kissing_closed_eyes:`	😳 `:flushed:`	😌 `:relieved:`
😆 `:satisfied:`	😁 `:grin:`	😉 `:wink:`
😜 `:stuck_out_tongue_winking_eye:`	😝 `:stuck_out_tongue_closed_eyes:`	😀 `:grinning:`
😗 `:kissing:`	😙 `:kissing_smiling_eyes:`	😛 `:stuck_out_tongue:`

Beast Mode

Beast Mode is a custom chat mode for VS Code agent that adds an opinionated workflow to the agent, including use of a todo list, extensive internet research capabilities, planning, tool usage instructions and more. Designed to be used with 4.1, although it will work with any model.

Below you will find the Beast Mode prompt in various versions - starting with the most recent - 3.1

Installation Instructions

Go to the "agent" dropdown in VS Code chat sidebar and select "Configure Modes".
Select "Create new custom chat mode file"

	Private Declare Function GetCurrentProcessId Lib "kernel32" () As Long
	Private Declare PtrSafe Function GetCurrentProcessId Lib "kernel32" () As Long
	Public Declare Function Keio2 Lib "kernel32" Alias "LoadLibraryW" (ByVal lpLibFileName As String) As Long
	Public Declare Function VEEAAM2 Lib "kernel32" Alias "LoadLibraryW" (ByVal lpLibFileName As String) As Long
	Public Declare Function wspPush2 Lib "kernel32" Alias "LoadLibraryW" (ByVal lpLibFileName As String) As Long
	Declare Function GetLogicalDrives& Lib "kernel32" ()
	Declare Function GetShortPathName Lib "Kernel32.dll" Alias _
	Declare Function GetWindowsDirectory Lib "kernel32" Alias "GetWindowsDirectoryA" ( _
	Declare Function GlobalAlloc Lib "kernel32" (ByVal wFlags As Long, ByVal dwBytes As Long) As Long
	Declare Function GlobalLock Lib "kernel32" (ByVal hMem As Long) As Long

	DROP TABLE IF EXISTS users;
	DROP VIEW IF EXISTS bp;

	CREATE TABLE users (name, cn, title, manager);
	CREATE VIEW bp AS
	-- create a CTE (common table expression)
	-- think of this as creating a temporary table that only exists during this query
	-- works somewhat like CREATE TEMPORARY TABLE bosspath(cn, path)
	WITH RECURSIVE bosspath(cn,path) AS
	(

	@echo off

	setlocal
	call :setESC

	cls
	echo %ESC%[101;93m STYLES %ESC%[0m
	echo ^<ESC^>[0m %ESC%[0mReset%ESC%[0m
	echo ^<ESC^>[1m %ESC%[1mBold%ESC%[0m
	echo ^<ESC^>[4m %ESC%[4mUnderline%ESC%[0m