Alex axrwkr

## planets.fsx
#r "FSharpx.TypeProviders.Freebase.1.6.137/lib/40/FSharpx.TypeProviders.Freebase.dll"

let ctx = FSharpx.TypeProviders.Freebase.FreebaseData.GetDataContext()

for e in ctx.``Science and Technology``.Astronomy.Planets do
  printfn "%s" e.Name

## ModifyExpression.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using System.Threading.Tasks;

namespace ModifyExpression
{
    class Program

## Program.cs
using SaveCount.Properties;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SaveCount
{
    class Program

## sln - black background.xml
<!-- NP++ Language menu ==> Define your Language ==> click Import in the window that just popped up -->
<NotepadPlus>
    <UserLang name="SLN" ext="sln" udlVersion="2.1">
        <Settings>
            <Global caseIgnored="no" allowFoldOfComments="no" foldCompact="no" forcePureLC="0" decimalSeparator="0" />
            <Prefix Keywords1="no" Keywords2="no" Keywords3="no" Keywords4="no" Keywords5="no" Keywords6="no" Keywords7="no" Keywords8="no" />
        </Settings>
        <KeywordLists>
            <Keywords name="Comments">03 04 00# 01 02</Keywords>
            <Keywords name="Numbers, prefix1"></Keywords>

## HelloWorld.html
<html>
  <head><title>hello world</title></head>
  <body>hello world</body>
</html>

## sln - white background.xml
<NotepadPlus>
    <UserLang name="SLN" ext="sln" udlVersion="2.1">
        <Settings>
            <Global caseIgnored="no" allowFoldOfComments="no" foldCompact="no" forcePureLC="0" decimalSeparator="0" />
            <Prefix Keywords1="no" Keywords2="no" Keywords3="no" Keywords4="no" Keywords5="no" Keywords6="no" Keywords7="no" Keywords8="no" />
        </Settings>
        <KeywordLists>
            <Keywords name="Comments">03 04 00# 01 02</Keywords>
            <Keywords name="Numbers, prefix1"></Keywords>
            <Keywords name="Numbers, prefix2"></Keywords>

## sql_autofix_example.sql
-- to list orphaned users
EXEC sp_change_users_login 'Report'

-- to fix a specific user (replace <user> with the user name)
EXEC sp_change_users_login 'Auto_Fix', [<user>]

-- to fix a user and create new login and password
EXEC sp_change_users_login 'Auto_Fix', [<user>], NULL, '<password>'

## clear_cache.aspx
<script language="C#" runat="server">
  protected void Page_Load(Object s, EventArgs e)
  {
      foreach (DictionaryEntry entry in HttpContext.Current.Cache){
          HttpContext.Current.Cache.Remove(entry.Key.ToString());
      }
  }
</script>

## permissions.sql
select schema_name(o.schema_id) as [Schema_Name]
, o.name as [object_name]
, u.name as [principal_name]
, u.type_desc as [principal_type]
, r.minor_id, r.permission_name, r.state_desc
, o.schema_id, o.principal_id as [alt_owner], o.type_desc
 from sys.database_permissions r
  Left Join sys.database_Principals u
	ON r.grantee_principal_id = u.principal_id
  Left Join sys.all_objects o

## xml dml delete examples.sql
DECLARE @myDoc xml
SET @myDoc = '<?Processing Instructions for=EXE.exe ?>
<root>
<!-- instructions for the 1st work center -->
<country LocationID="10"
            GDP="1.1"
            GNI=".2" >Some text 1
<city id="1">London</city>
<city>Manchester</city>
<city id="3">Liverpool</city>
	#r "FSharpx.TypeProviders.Freebase.1.6.137/lib/40/FSharpx.TypeProviders.Freebase.dll"

	let ctx = FSharpx.TypeProviders.Freebase.FreebaseData.GetDataContext()

	for e in ctx.``Science and Technology``.Astronomy.Planets do
	printfn "%s" e.Name
	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Linq.Expressions;
	using System.Text;
	using System.Threading.Tasks;

	namespace ModifyExpression
	{
	class Program
	using SaveCount.Properties;
	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Text;
	using System.Threading.Tasks;

	namespace SaveCount
	{
	class Program
	<!-- NP++ Language menu ==> Define your Language ==> click Import in the window that just popped up -->
	<NotepadPlus>
	<UserLang name="SLN" ext="sln" udlVersion="2.1">
	<Settings>
	<Global caseIgnored="no" allowFoldOfComments="no" foldCompact="no" forcePureLC="0" decimalSeparator="0" />
	<Prefix Keywords1="no" Keywords2="no" Keywords3="no" Keywords4="no" Keywords5="no" Keywords6="no" Keywords7="no" Keywords8="no" />
	</Settings>
	<KeywordLists>
	<Keywords name="Comments">03 04 00# 01 02</Keywords>
	<Keywords name="Numbers, prefix1"></Keywords>
	<html>
	<head><title>hello world</title></head>
	<body>hello world</body>
	</html>
	-- to list orphaned users
	EXEC sp_change_users_login 'Report'

	-- to fix a specific user (replace <user> with the user name)
	EXEC sp_change_users_login 'Auto_Fix', [<user>]

	-- to fix a user and create new login and password
	EXEC sp_change_users_login 'Auto_Fix', [<user>], NULL, '<password>'
	<script language="C#" runat="server">
	protected void Page_Load(Object s, EventArgs e)
	{
	foreach (DictionaryEntry entry in HttpContext.Current.Cache){
	HttpContext.Current.Cache.Remove(entry.Key.ToString());
	}
	}
	</script>
	select schema_name(o.schema_id) as [Schema_Name]
	, o.name as [object_name]
	, u.name as [principal_name]
	, u.type_desc as [principal_type]
	, r.minor_id, r.permission_name, r.state_desc
	, o.schema_id, o.principal_id as [alt_owner], o.type_desc
	from sys.database_permissions r
	Left Join sys.database_Principals u
	ON r.grantee_principal_id = u.principal_id
	Left Join sys.all_objects o