ITDevSpace - Development Tips & Tricks

import com.sun.net.httpserver.HttpExchange; import com.sun.net.httpserver.HttpHandler; import com.sun.net.httpserver.HttpServer; import java.io.IOException; import java.net.HttpURLConnection; import java.net.InetSocketAddress; public class TestServer { private static final int PORT = 8000; private static final String HOST = " 127.0.0.1 "; 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.

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