Question: How do I check strings that have only alphanumeric characters? Answer: When you say alphanumeric, I assume you mean that the characters are in one of the following domains:

Question: I have a table with column called Date, which stores date record, that was entered in smalldatetime format (e.g., 2000-06-01 00:00:00). I need to write a stored procedure that

Question: I would like to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static

Question: I am facing a problem with the following SQL stored procedure: CREATE PROCEDURE usp_CreateAdminUser /*Input Parameters for the Create Admin User */ @FullName varchar(100), @Telephone varchar(50), @Email varchar(50), @Address1

Question: I have a stored procedure that takes a costcenterid (int) as an input parameter. The user wants to search on an unspecified number of costcenters each time. I use

Question: Can I get a list of the columns and datatypes that are returned from a stored procedure without executing the procedure? Answer: There’s no way of doing this using

Question: I need to pass the @TheVar variable to the stored procedure’s IN statement but I keep getting zero records. If I type this statement into the SQL… WHERE Name

Question: Is it possible to create tables in stored procedures using a variable for the table name? For instance: declare @MyNameset @MyName = ‘dbo.Unique_Name’create table @MyName … This obviously doesn’t

Question: I write a stored procedure and it works fine. But when I do write a “select statement” as below: “select * from sp_name” I get an error message: “Server:

Question: What causes the error message”Invalid seek offset”? Answer: This message is often a symptom of a corrupted index. You may want to rebuild the indices of whatever table you

ADO 2.1 added a new, important dynamic property to the Field object, the OPTIMIZE property. If you have a client-side Recordset and you set this property to True, ADO will

The String$ function can replicate only 1-char strings, so it seems that you need a loop to duplicate strings that contain 2 or more characters. However, this is a one-liner

The GetString method of the Recordset object returns a formatted string that contains all the values in each field and each row in the recordset, with your choice of column

Reading and writing an item of an array is always slower than accessing a simple variable. Therefore, if you need to repeatedly use the same array item in a loop,

As you probably know, the “&” operator is rather slow, especially with long strings. When you have to repeatedly append chucks of characters to the same variable, you can speed

‘ Filter out all invalid characters in a string.Function FilterString(text As String, ValidChars As String) As String Dim i As Long, result As String For i = 1 To Len(text)

As explained in another item in this Tip Bank, you can use the Recordset’s GetString method to export a Recordset to a comma-delimited or tab-delimited text file. However, if you

When you want to assign a control’s Font to another control, the first obvious way is to assign the Font property directly, as in: Set Text2.Font = Text1.Font but in

It seems that you need two nested For loops to iterate over all the elements of a 2-dimensional array, and three loops for a 3-dimensional array, and so on. However,

Do you have problems with the spacing that HTML line breaks and paragraph tags give?Or have you ever wanted leading that was in-between the two or just a little more

Question: Is there a simple way of copying a file from one directory to another? Answer: There is no predefined convenient method for copying a file from oneplace to another.

Question: When I use onstat -d, the message “No response from server process” pops up. Then I can’t shutdown the database or do any other jobs. I could use dbaccess,

Question: I’m trying to translate from VC++ to Java. Can you declare a variableDWORD in Java? If not, what is the Java equivalent? Also, what is theequivalent for HINSTANCE? Answer:

Question: Is there something similar to the C/C++ compiler directive #ifdef,#define, and #endif in Java? I would like to compiledebugging code conditionally. Answer: This is one of the first questions

Question: I’m using a catch(exception e). When I come in the catch-block and print the message belonging to the exception, I receive the message “9exception.” What does it mean? Answer:

Question: I am calling a java program from a Unix script and passing threeparameters. Once the Java program is done, I want to return two valuesback to the Unix program

Question: How do I restrict the number of characters to be entered in a TextField? Answer: Setting a maximum character count is not a built-in function ofTextField. You have to

Question: An error occurs in the Exchange event log stating that my customers are out of licenses when clearly they are not. How come? Answer: Since they have enough legal

Question: Why do I have to catch an exception when I use System.in.read()? Answer: System.in is an InputStream, and like any InputStream, an I/O errormay occur when you read from