Windows - Concatenate multiple text files into one

In cmd:

type *.txt > OneFileName.txt

netstat - network statistics

netstat is a command displays statistics on all network activities.

main options:

-a Displays all active ports

-n Numerical display of addresses and port numbers

-o Displays the process identifiers (PID)

| grep 11753 - displays information only for IP 11753 (or other filter)

netstat -a -n | grep 11753

CMD - Displays and uses all commands you did

Maybe better than copy-paste for CMD :)

In Windows Command Prompt, F7 displays all commands you did before, so you can use it again without typing again - just go up and down with the arrays and press Enter when you are on the command you need.

Increase the width of isql output

In order to increase the width of isql output add -w2048 in the enf of the command (2048 is the width, it can be changed to ither number)

isql64 -S RSFOG2 -Usa -Pdba4ever -w2048

CMD - Copy Folder's files list to a texst file

dir /on/b > 1.txt

Connect to isql

isql Uusername Ppassword [Sserver]

(U , P , S - as is and then replace to the user, password, ...)
( Pay attention: names are case-sensitive )

Copy few files Content into one file

C:\Documents and Settings\itaig>copy "C:\Projects\\Scripts\Stored Procedures\*.*" "C:\Projects\Scripts\Stored Procedures\a.sql"