zippy1981

DROP TABLE etr;
GO

CREATE TABLE etr ( 
      col_1 real NOT NULL,
      col_2 real NOT NULL,
      col_3 real NOT NULL,
      col_4 real NOT NULL,
      col_5 real NOT NULL,
      col_6 real NOT NULL,

zippy1981

C:\Users\zippy>pathed /machine /remove 27
PATHED - Version 3.2
Freeware written by Gerson Kurz (http://p-nand-q.com)

00 C:\Program Files (x86)\PHP
01 C:\Windows\system32
<snip> . . . . . .</snip>
25 c:\Program Files\MongoDB\mongodb-win32-x86_64-1.8.1\bin
26 c:\Program Files (x86)\GnuWin32\bin
27 c:\Program Files\TortoiseHg

zippy1981

#Updated at Sun Jun 05 14:55:40 EDT 2011
#Sun Jun 05 14:55:40 EDT 2011
database.password=postgres
database.url=jdbc\:postgresql\://localhost\:5432/myproject
database.username=postgres
database.driverClassName=org.postgresql.Driver

zippy1981

[string] $mongoDriverPath;
# Check to see if we are running the 64 bit version of Powershell. 
# See http://stackoverflow.com/questions/2897569/visual-studio-deployment-project-error-when-writing-to-registry
if ([intptr]::size -eq 8) {
    $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.0").'(default)';
}
else {
    $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.0").'(default)';
}

zippy1981

[string] $mongoDriverPath;
# Check to see if we are running the 64 bit version of Powershell. 
# See http://stackoverflow.com/questions/2897569/visual-studio-deployment-project-error-when-writing-to-registry
if ([intptr]::size -eq 8) {
    $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.0").'(default)';
}
else {
    $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.0").'(default)';
}

zippy1981

# Loosely based on http://www.vistax64.com/powershell/202216-display-image-powershell.html

[void][reflection.assembly]::LoadWithPartialName("System.Windows.Forms")

$file = (get-item 'C:\Users\Public\Pictures\Sample Pictures\Chrysanthemum.jpg')
#$file = (get-item "c:\image.jpg")

$img = [System.Drawing.Image]::Fromfile($file);

# This tip from http://stackoverflow.com/questions/3358372/windows-forms-look-different-in-powershell-and-powershell-ise-why/3359274#3359274

zippy1981

#!/usr/bin/perl
use strict;
use DateTime;

my $dt = DateTime->now();

# We can't call it $7zip because variable names can't begin with a number.
#my $lzexe;

my $lzexe = get7Zip();

zippy1981

# We assume that the driver is installed via the MSI.

[string] $mongoDriverPath;
# Check to see if we are running the 64 bit version of Powershell. 
# See http://stackoverflow.com/questions/2897569/visual-studio-deployment-project-error-when-writing-to-registry
if ([intptr]::size -eq 8) {
    $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.0").'(default)';
}
else {
    $mongoDriverPath = (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\.NETFramework\v3.5\AssemblyFoldersEx\MongoDB CSharpDriver 1.0").'(default)';

zippy1981

# Adjust these per your environment
[string] $AtlantisSchemaEngineBaseDir = 'F:\src\Atlantis.SchemaEngine\';
[string] $SqlServerInstance = 'localhost\SQLEXPRESS2k8R2';
[string] $dbName = 'master'

# This line works:
Add-Type -Path "$($AtlantisSchemaEngineBaseDir)\Atlantis.SchemaEngine\bin\Debug\Atlantis.SchemaEngine.dll"

[string] $cnStr = "Data Source=$SqlServerInstance;Initial Catalog=$dbName;Integrated Security=SSPI;";

zippy1981

USE [master]
GO

IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'TestAssembly')
BEGIN
	ALTER DATABASE [TestAssembly] SET OFFLINE WITH ROLLBACK IMMEDIATE;
	ALTER DATABASE [TestAssembly] SET ONLINE;
	DROP DATABASE [TestAssembly];
END
GO