
Exporting SQL Server Results to XML
Beginning with SQL Server 2000, Microsoft added support for SQL-XML interoperability. They did this by expanding some statements that we all know
Beginning with SQL Server 2000, Microsoft added support for SQL-XML interoperability. They did this by expanding some statements that we all know
Memory is precious in Palm OS, so you can’t afford any memory leaks in programs. Therefore, it’s very essential to detect any memory leaks. To do this put breakpoints in the program where you want to find any memory leaks. When the program stops at the breakpoint, go to “Show
Beginning with SQL Server 2000, Microsoft added support to retrieve data from SQL Server databases by using an URL address. To do this, you must create a virtual root, that is, a virtual address that your Website visitors can see. To do that, use the ‘Configure SQL XML Support in
Everybody knows that the WM_PAINT message is passed to a window whenever it needs to be painted. Usually, we code all of our painting instruction in the handler of WM_PAINT, including the background of our painting items. What actually happens is that a WM_ERASEBKGND is also passed prior to sending
In order to increase the efficiency of your linear searching, add the item you are searching at the end of the list (either an array or linked list) and write the following code for searching: BOOL Find(const int *pAListWithSearchedItemAtTheEnd, int nlength){ for (int i=0;; i++) { if (pAListWithSearchedItemAtTheEnd[i] ==pAListWithSearchedItemAtTheEnd[nlength-1]) break;
The C++ runtime library includes a heap manager (subroutines responsible for maintaining the heap). The heap manager does bookkeeping to keep track of which parts of the heap have been loaned out for usage (allocated), and which parts are still free (deallocated).Every time a call to ‘new’ is made, the
This is a simple way to find out the word count in a comma delimited string: declare @mystring varchar(200)set @mystring=”vb,asp,sqlserver,html”select (len(@mystring)-len(replace(@mystring,’,’,”))+1) The following code will parse the delimited string: –variable i is for current and j for previous locationsDECLARE @mystring varchar(255), @myword varchar(50)DECLARE @i int,@j intSELECT @mystring = ‘vb,asp,sqlserver,html’SELECT @i
Debugging a multi-threaded program in Visual C++ may be difficult, especially when switching between multiple threads using the Debug/Threads menu. One efficient way to distinguish threads during debugging is to give them names using an undocumented feature based on SEH (Structure Exception Handling).In the thread you want to set the
If you find yourself constantly commenting and uncommenting bits of code during development, this tip could come in handy. Normally, you’d do something like this: #define /* #undef */ _FOObool x = true; // = false; Instead, use C style commenting to your advantage: /**/ #define /*/ #undef /**/ _FOObool