On 8/5/2010 10:35 PM, SharkD wrote:
> They have an awesome set of tutorials that kind of make up for it. I
> would much rather use a scripting language (or less preferably XML)
> instead of tacking on an endless series of command-line arguments, though.

Also, ImageMagick's command-line syntax still makes 10x more sense than 
SQL. For example:

  INSERT INTO clients
  (client_id, client_name, client_type)
  SELECT supplier_id, supplier_name, 'advertising'
  FROM suppliers
  where clients.client_id = suppliers.supplier_id);

The first set of column names is contained in parentheses, the second 
set isn't.

When creating filegroups you don't use quotes:

   ALTER DATABASE AdventureWorks ADD FILEGROUP MyFileGroup

When adding files to them you do use them:

   ALTER DATABASE AdventureWorks
   ADD FILE
   (NAME = N'MyFileGroup',
   FILENAME = N'C:\AdventureWorks\MyFileGroup.ndf',
   SIZE = 5MB,
   MAXSIZE = 100MB,
   FILEGROWTH = 5MB)
   TO FILEGROUP MyFileGroup

Conditional IF statements don't use brackets or a keyword to close the 
block (though I just learned that you can optionally surround the block 
with BEGIN and END).



-- 
http://isometricland.com

Post a reply to this message