smnb

# for x in O*.jpg; do echo $x ; convert "$x" -crop 1360x1700+0+0 "a_$x"; do ne
# for x in a_*; do echo "$x" ; mv "$x" "${x#a_}" ; done

$ grep pdf index.html  | sed s/.*http:/http:/ | sed s/\.pdf.*/.pdf/ > aaa
$ cat aaa | while read line; do wget $line; done

$netstat --tcp --listen

ref:netstat

$ tar czO photo_index.exe | ssh smnb@vista 'cat > photo_index.tar.gz'
$ ssh smnb@vista 'cd /tmp; tar czO a.jpg' | tar xvzf- 

uname -r

シェルスクリプトでカラム表示とかセンタリング表示とか

awk '{ print NR, $0 }' 

$ cat aaa.html | sed 's/\([^>]*\)>/\1>\n/g' > bbb

make -p  /very/deep/dir/can/be/made/using/this/option

$ sqlcmd -S .\\SqlExpress -E -Q "select name from sysdatabases"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select name from sysobjects where xtype = 'U' or xtype = 'S' order by name"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "create table CardInfo( CardID nchar(6), CustomerID nchar(5), IssueDate datetime, EmployeeID int)"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "sp_help CardInfo"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "if exists (select * from sysobjects where id = object_id(N'[dbo].[CardInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [dbo].[CardInfo]"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "alter table CardInfo add Status nchar(6)"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "alter table CardInfo drop column Status"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "insert into CardInfo ( CardID, CustomerID, IssueDate, ExpireDate, EmployeeID) values ('NW0001','ALFKI','2001/4/1','2002/3/31','7')"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from CardInfo where CardID like 'NW%%'"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "update CardInfo set ExpireDate='2004/1/3' where CardID = 'NW0001'"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from CardInfo where CardID like 'NW%%'"

$ sqlcmd -S .\\SqlExpress -i myScript.sql > employee.lst

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from Customers"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from Orders where CustomerID = 'QUICK' and OrderDate > '1998/1/1'"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from Orders where OrderDate between '1996/1/1' and '1997/12/31'"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from Orders where CustomerID in ('QUICK','VINET')"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from Orders where CustomerID like 'Q%%'"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select CustomerID from Customers where CustomerID like 'TR__H'"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select CustomerID, CompanyName from Customers order by CompanyName desc"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select CustomerID, CompanyName from Customers order by CompanyName asc"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select ProductID, Sum(Quantity), Avg(UnitPrice), Max(UnitPrice), Min(UnitPrice), Count(ProductID) from [Order Details] group by ProductID"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select OrderID, Prd.ProductID, ProductName, Prd.UnitPrice, Quantity, Discount from [Order Details] Ord inner join Products Prd on Ord.ProductID=Prd.ProductID"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select top 5 ProductID, ProductName, UnitPrice from Products order by UnitPrice desc"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from Products Prod1 where Prod1.UnitPrice > all( select UnitPrice from Products Prod2 where Prod1.ProductID <> Prod2.ProductID)"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from Products where UnitPrice >= all ( select UnitPrice from [Order Details])"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from Products where UnitPrice < ( select avg(UnitPrice) from [Order Details])"
$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select * from Customers where CustomerID = any( select distinct(CustomerID) from Orders)"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select distinct(CustomerID) from Orders"

$ sqlcmd -S .\\SqlExpress -E -d Northwind -Q "select CustomerID, ContactName, Phone, Fax from Customers where Fax is Null"

XP