The following query will list all the stored procedure names available in the current database: SELECT name AS spnameFROM sysobjectsWHERE (xtype = ‘p’) AND (name NOT LIKE ‘dt%’)ORDER BY name
Using the callback function in C is pretty straightforward, but in C++ it becomes little tricky. If you want to use a member function as a callback function, then the
Have you ever implemented a method and wanted to return the value of a variable and then clear (or change) the variable? Since you can’t typically execute another line of
In Servlets/JSPs, there are two ways to achieve servlet chaining using javax.servlet.RequestDispatcher: Include: RequestDispatcher rd = req.getRequestDispatcher(“Servlet2”);rd.include(req, resp); Forward, where req is HttpServletRequest and resp is HttpServletResponse: RequestDispatcher rd =
In order to debug ASP pages in Visual Interdev, you need to change some some IIS settings. Open the Internet Service Manager console (using the inetmgr command on Start?>Run). Right
Pressing Ctrl + C in the table view of Enterprise Manager copies the create table statement along with constraints, defaults, etc. to the clipboard.
You can use this algorithm to reverse the order of elements in any sequence container. It takes two bidirectional iterators as argument: int iArr [] = {1, 2, 3, 4,
Suppose you’ve got a make-table query using an INTO clause in an MS ACCESS SQL SELECT statement. You can actually send the resultset to a text file instead of a
You already know that stored procedures offer enormous benefits over direct SELECT statements. But one of the things you tend to have to sacrifice when you replace a simple SELECT