Jeremy Simmons: The Blog

It's every so important to read the syntax carefully in computer science. Missing the specifics will get you every time.

Compare these two statements.

DECLARE @sql VARCHAR(8000)
SET @sql = 'SELECT CustomerID FROM Customers'
EXEC @sql

to this

DECLARE @sql VARCHAR(8000)
SET @sql = 'SELECT CustomerID FROM Customers'
EXEC(@sql)

I'm sure you've caught it by now. It's the parenthesis.

Syntax

Execute a stored procedure:

[ [ EXEC [ UTE ] ]
    {
        [ @return_status = ]
            { procedure_name [ ;number ] | @procedure_name_var
    }
    [ [ @parameter = ] { value | @variable [ OUTPUT ] | [ DEFAULT ] ]
        [ ,...n ]
[ WITH RECOMPILE ]

Execute a character string:

EXEC [ UTE ] ( { @string_variable | [ N ] 'tsql_string' } [ + ...n ] )

It's even in bold in the documentation. One would think it might jump out and grab my attention. However sadly, it did not.

I could not find this easily on the web, so I hope this saves someone a search.

Take the following under consideration

string root = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);

// We're interested in details, so we'll work with DirectoryInfo instead of Directory and strings
DirectoryInfo rootDirectory = new DirectoryInfo(root);
DirectoryInfo[] subDirectories = rootDirectory.GetDirectories("*", SearchOption.AllDirectories);

DirectoryInfo[] hiddenDirectories =
Array.FindAll<DirectoryInfo>(subDirectories,
delegate(DirectoryInfo d)
{
return (d.Attributes & FileAttributes.Hidden) == FileAttributes.Hidden;
});

It's wasn't immediately obvious to me how the syntax for Array.FindAll<T> worked. I hope this clears up any confusion in the future.

As a side note. C# 3.0 is the cats meow. This is not 100% equivalent to the above. I think we can all agree we're getting closer to expressing programmers intent.

string start = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);

DirectoryInfo root = new DirectoryInfo(start);

var subDirectories = root.GetDirectories("*", SearchOption.AllDirectories).AsQueryable();

Using the Disk Utility application on OSX, it's easy to get an image of a CD as a file on the hard drive.
The unortunate thing is that the image file is going to be a DMG by default.

I wanted to convert this to an ISO, so I could burn the file to media later with software that understood this format.

Conversion is fairly painless. Drop to your console, and use the following.

hdiutil convert /path/to/filename.dmg -format UDTO -o /path/to/savefile.iso