Tip Bank

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: 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 would like to build a stored procedure that will receive a table name as a parameter. It then will select the data I want into whatever table name

Question: I noticed that MSDN contains sp_OAStop, which shuts down the OLE environment that starts inside SQL Server the first time you call sp_OACreate. But I can’t figure out what

Question: How do I create a new table? Answer: The DLL syntax for creating a table intuitively is the CREATE TABLE command. You can specify all the options for the

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