|
![](/i/fill.gif) |
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
|
![](/i/fill.gif) |