Category Archives: tips and tricks

Collection of things I think are helpful

PayPal test credit card numbers

Posted on 12/28/2010 by Eric Fickes

Test Credit Card Account Numbers While testing, use only the credit card numbers listed here. Other numbers produce an error. Expiration Date must be a valid date in the future (use the mmyy format). Test Credit Card Account Numbers Credit Card … Continue reading →

Posted in development, internets, tips and tricks | Tagged , , | Leave a comment

How to get windows on VMWare to see your windows network

Posted on 12/10/2010 by Eric Fickes

Set network connection to bridged. Permalink | Leave a comment

Posted in apple, osx, tips and tricks | Leave a comment

TSQL : How to find all database tables ending with an UPPERCASE X

Posted on 12/08/2010 by Eric Fickes

1 2 3 4 5 6 7 8 9 10 — Give me all tables ending with an UPPERCASE X SELECT table_name, SUBSTRING( table_name, LEN(table_name), 1 ) as 'end' FROM INFORMATION_SCHEMA.TABLES — SELECT ascii('X') = 88 — SELECT ascii('x') = … Continue reading →

Posted in database, internets, SQL, tips and tricks, tsql | Leave a comment

Selecting random ids using TOP and a CTE

Posted on 09/29/2010 by Eric Fickes

While testing visualizations in a Flex application, I needed to do some underlying data cleanup in SQL Server.  One of my tasks was to manually update an entity table and set the status column to one of three possibilities.  Status … Continue reading →

Posted in database, SQL, tips and tricks, tsql | Tagged , , , , , , , | Leave a comment