October 9, 2001

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

Detecting Memory Leaks in Palm OS

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

Retrieve SQL Server Results in XML through an HTTP Connection

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

Efficient Window Client Area Painting in VC++

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

Improve Linear Searching

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;

How Do ‘New’ and ‘Delete’ Actually Work?

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

Dealing with Delimited Strings in T-SQL

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

Naming a Thread

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

Toggle Code Blocks with C Comments

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

No more posts to show