Tip Bank

Question: I am interested in keeping my code running as fast as possible. Is there a cost associated with making my methods synchronized, and if so, how significant a cost?

Question: Can I create a table in a stored procedure named from a parameter? Answer: You can dynamically create tables with variables, but you need to create a string and

Question: How do I get the rowseffected from the execute method of an ADO command object?The code I’ve written is: Dim Cn as New ADODB.ConnectionDim Cmd as New ADODB.CommandDim Recordset

Question: Can you use the indirection operator like a memcpy to copy the contents of a structure like this? *m_pMyInfo = stMyInfo; Or should you use the memcpy function? memcpy(m_pMyInfo,

Question: How do I count the number of duplicate items in a table? Answer: Lets break down your question into several steps.First, let’s create a sample table using the following

Question: How do I write a query that does an insert and returns the newly assigned ID from that field, all at one time? Answer: The @@IDENTITY variable returns the

Question: How do I list the available tables in a database I’m querying? Answer: You can get a list of tables in a database by calling the INFORMATION_SCHEMA.Tables view like

Question: While converting source code from C to C++, I came up with difficulties in converting error handling routines like err_quit(),err_sys(),etc. Are there C++ versions of these functions and where

Question: When I try to send e-mail to the distribution list, it gets stuck in outbox. What should I do? Answer: I’d start by verifying that all of the addresses