select * from foo where bar_date=to_date(‘22-FEB-2012’,’dd-MON-yyyy’)
How to search the content of stored procedures in a SQL Server 2005 database:
SELECT Name, OBJECT_DEFINITION(OBJECT_ID)
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%SEARCH_TERMS%'
When using PuTTY, an ssh session to a remote server can be disconnected due to inactivity. If you need to make sure the connection is maintained you can send keepalives - small regular blips of data - to the remote server. Keepalives are enough to convince the server that the connection is still active.
To turn keepalives on go to the top level of the section Connection on the PuTTY Configuration screen. The setting for keepalives is at the top. It is labeled “Sending of null packets to keep session active”. The setting itself is labeled “Seconds between keepalives (0 to turn off)” and the default value is 0 for off. Change this to a non-zero value (10 is good) to turn keepalives on.
