June 12, 2000

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: 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 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 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: 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: When using the following commands to modify a dbf file, I find the file is not accessible for modification: USE MODIFY STRUCTURE How do I modify the file structure?

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