Showing posts from February, 2011

How to Hide/Show rows dynamically in Excel


Simple Java HttpServer / HttpHandler

import; import; import; import; import; import; public class TestServer { private static final int PORT = 8000; private static final String HOST = " "; public static void main(String[] args){ System.out.println(" Starting HttpServer on port "+PORT); try { InetSocketAddress address = new InetSocketAddress(HOST, 8000); HttpServer httpServer = HttpServer.create(address, 0); System.out.println(" Running.. "); HttpHandler handler = new HttpHandler() { public void handle(HttpExchange exchange) throws IOException { String response = " Hello World! "; byte [] bytes = response.getBytes(); exchange.

SQL Server How to find if any stored procedure is referencing database object

select StoredProcedureName = from sys.sql_modules sm inner join sys.procedures p on sm.[object_id] = p.[object_id] where [definition] like ' %Database_Object_Name% '