Tip Bank

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

Question: Every time I try to use a wizard, I get the following error message: “Cannot find the Wizard Program.” The wizards are located in the same folder that I

Question: I have a field that stores lots of data (up to 8,000 characters). I thought that I could maybe save disk space if I stored this data as varbinary

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: How do I control the output format for the list structure command so that it always fits on a page (portrait or landscape)? Is there another way to get

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 want to order the output of my query by two fields. Is this possible? That is, if two values are the same, I want the output ordered by

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: 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