Tip Bank

Question: If my SQL Server has the following specs: 6.05.02 SQL-DMO6.50.252 DB-Library Which version do I have? And which service pack version do I have? Answer: If you want to

Question: Error 208 appears regularly on my IBM RS6000 running Informix 7.3. The onconfig setting for shared mem is 0 ( no limit). What do I do about this? Answer:

Question: I have seen a lot of XML editors coming out, and there are some that are very good. For me at least, developing the XSL has been more difficult

Question: I’m trying to retrieve the “firstname” and “lastname” fields from a SQL Server database, place them into a column called “fullname” using the AS statement. When I simply retrieve

Question: I have an ASP application that retrieves several rows from a database using ADO. For those users who have a slower connection, I would like to know if there

Question: How do I get the average of three columns for each row of a table that has four columns of information? Answer: Let’s say you have a table called

Question: I keep getting a syntax error on the last part of this statement: “SELECT DISTINCT [Company Name], [Street Address] FROM ” & d & ” WHERE[Street Address] !=” Maybe

Question: How do I send an e-mail to myself if a field reads “SEND_MAIL?” For example, a user wants more info on a product, so he clicks on the Send

Question: How do I compare two values when one value(data type) is char and the other is an integer? Answer: For this you can use the CONVERT function. Since you