Tuesday, March 29, 2011

FTP from command prompt

C:\>ftp ftp.server.com
Connected to ftp.server.com.
220 You have connected to ftp.server.com
User (ftp.server.com:(none)): username
331 User name okay, need password.
Password:
230 User logged in, proceed.
ftp> dir
200 PORT Command successful.
150 Opening ASCII mode data connection for /bin/ls.
drw-rw-rw- 1 user group 0 Feb 8 16:10 .
drw-rw-rw- 1 user group 0 Feb 8 16:10 ..
drw-rw-rw- 1 user group 0 Oct 25 10:00 blah
drw-rw-rw- 1 user group 0 Oct 21 12:17 blah2
4 Transfer complete.
ftp: 2987 bytes received in 0.25Seconds 11.95Kbytes/sec.
ftp> cd blah2
250 Directory changed to /blah2
ftp> dir
200 PORT Command successful.
150 Opening ASCII mode data connection for /bin/ls.
drw-rw-rw- 1 user group 0 Feb 8 16:22 .
drw-rw-rw- 1 user group 0 Feb 8 16:22 ..
-rw-rw-rw- 1 user group 13824 Feb 8 16:22 test spreadsheet only.xls

226 Transfer complete.
ftp: 199 bytes received in 0.00Seconds 199000.00Kbytes/sec.
ftp> put C:\LocalMachine\Applications\ConsolidatedData.xls
200 PORT Command successful.
150 Opening ASCII mode data connection for consolidateddata.xls.
226 Transfer complete.
ftp: 640512 bytes sent in 6.38Seconds 100.47Kbytes/sec.
ftp> dir
200 PORT Command successful.
150 Opening ASCII mode data connection for /bin/ls.
drw-rw-rw- 1 user group 0 Feb 9 09:37 .
drw-rw-rw- 1 user group 0 Feb 9 09:37 ..
-rw-rw-rw- 1 user group 640512 Feb 9 09:37 consolidateddata.xls
-rw-rw-rw- 1 user group 13824 Feb 8 16:22 test spreadsheet only.xls

226 Transfer complete.
ftp: 276 bytes received in 0.00Seconds 276000.00Kbytes/sec.
ftp>


* Note: To send a link directly to ftp with the credentials within the link, it should be in the form: ftp://blah:pa3sw0rd@ftp.server.com

Wednesday, March 9, 2011

SQL detect table data change with Update Trigger

ALTER TRIGGER [dbo].[Table_OnUpdate] ON [dbo].[Table]
FOR UPDATE
AS

DECLARE @firstname_changed BIT
DECLARE @lastname_changed BIT
DECLARE @middlename_changed BIT

SELECT
@firstname_changed = CASE WHEN i.firstname <> d.firstname THEN 1 ELSE 0 END,
@lastname_changed = CASE WHEN i.lastname <> d.lastname THEN 1 ELSE 0 END,
@middlename_changed = CASE WHEN i.middlename <> d.middlename THEN 1 ELSE 0 END
FROM inserted i INNER JOIN deleted d ON i.tableid=d.tableid

IF ((@firstname_changed = 1) OR (@lastname_changed = 1))
BEGIN
--Table data changed
END