Tip Bank

DevX - Software Development Resource

Table Columns

Question: How do I drop a table column? Answer: To drop a column, use this syntax: ALTER TABLE Employees DROP COLUMN HomePhone Just remember that you can’t drop a column

DevX - Software Development Resource

Deadlock Timeouts

Question: I have two questions: 1. How can I determine what the server’s lock mode currently is (e.g. WAIT, NO WAIT, etc.), without actually setting it at the same time?

DevX - Software Development Resource

GetCpuInfo – Retrieve information about the CPU

Const HKEY_LOCAL_MACHINE = &H80000002′ Information about the CPU’ you can pass a number 1 to the last argument to retrieve’ information on all the processors in a multi-CPU system” Returns

DevX - Software Development Resource

NumberOfCPUs – The number of processors

Const HKEY_LOCAL_MACHINE = &H80000002′ Return the number of processors” Requires the CheckRegistryKey routineFunction GetNumberOfCPUs() As Integer Dim keyName As String ‘ loop on the subkeys of HKEY_LOCAL_MACHINEHardwareDescriptionSystem ‘ CentralProcessor ‘