When you deal with unknown return values or variant variables whose types might be unknown, you may not know whether the value of the variable is an EMPTY string or
The array subscript operator, [], has a higher precedence than the pointer dereference operator, *. Therefore, the following snippet declares an array of 10 pointers to char, not a pointer
Question: Can I use a user-defined data type when defining a temporary table in a stored procedure? Answer: You can use user-defined data types in temporary tables, but remember one
Question: Is there a non-platform-specific SQL way of determining what data type a given field is? Answer: That information is specific to each database. Every product stores its meta data
Const INTERNET_OPEN_TYPE_PRECONFIG = 0Const INTERNET_FLAG_EXISTING_CONNECT = &H20000000Private Declare Function InternetOpen Lib “wininet.dll” Alias “InternetOpenA” _ (ByVal lpszAgent As String, ByVal dwAccessType As Long, _ ByVal lpszProxyName As String, ByVal lpszProxyBypass
Question: Can I auto start full text index? Answer: Although Enterprise Manager doesn’t provide the option, you can set this service to start automatically by using the services icon in
Question: How do I create a stored procedure that will construct and execute a query from its parameters? At the heart I’d imagine something like this, for simplicity’s sake: declare
Question: How do I convert a number that represents a date into a date field? The number’s format is CCYYMMDD. Answer: Fortunately, the format of your numeric value doesn’t need
Question: I have two similar tables with monthly data: one holds current year data and the other holds prior year data. How do I combine them to create a rolling