Question: When I run a stored procedure which uses cursors to do a selection of counts based on a view, it returns the correct (expected) numbers. However, when I rerun

Question: What is the syntax for inserting multiple records into a single query. I have some files with thousands of records to insert and it’s too slow using Insert into

Question: Where can I find miscellaneous information about SQL on the web? If you know of anyuseful websites with history, general structure, etc…, of SQL, please let me know. Answer:

Question: Currently, I use SQL Mail in SQL Server 7.0 with Outlook and Exchange Server. I am sure there were no errors during set up, but when I went to

Question: I’m looking for other tools for importing ASCII files to SQL server 7.0 without problems. At this moment I’m missing data and the tools can’t take care of it

Question: I am using SQL+ through COBOL to include a 250 char notes field on a report. If the user has entered a return character in the field (Hex 0A),

Question: We are always getting “stored procedure not found” error messages. We know it is on the server and we can access the db. Any clues? Answer: Well, if you

Question: I’ve got a table structure that looks like the following:Customer TableCUST_IDNAMECODE_LISTCode TableCUST_IDCODE The code table can have any number of codes for each customer. I’m trying to find a

Question: I’m curious to know, if I have a file full of data separated by commas, how do I read stuff from that file into SQL tables? Answer: The fastest

Question: How do I retain the results of a query for use in subsequent queries using SQL Server? Answer: Well, you could either INSERT or INSERT SELECT your query into

Question: Is there a SQL statement for deleting tables like there is for deleting data from tables? Something like:DELETE TABLE NAME or DROP TABLE NAME Answer: Yes indeed, Drop table

JavaScript functions have a special property called arguments, which contains an array of input parameters. Using the “length” property of an array, you can iterate through the array for each

A Recordset without a live connection to a database server is called a disconnected Recordset. After the client machine receives the disconnected Recordset, it can use ADOR Recordset to manipulate

Question: I am having trouble figuring out how to make a report dealing with duplicates. I need to selcet from a table only instances where the first 10 characters of

Question: I’m trying to get the Identity of records as I insert them into my database. I have tried: OrderID = DataConn.Execute(“SELECT @@IDENTITY FROM Orders”). But this returns a syntax

Question: I have a field in one of my SQL Server Database tables which I want to increment every time a user enters a new record. I thought about a

Question: I have a table with a datefield as part of the key. This was needed because it stores historical information. I need to know how to write an SQL

Question: Is there a way to have SQL Server assign values to key fields automatically, so that every time a new record is added it just increases the prior record’s

Question: Please describe the basic components of a table in the relational model. Answer: A table has an intension and an extension. You can think of the intension of a

Question: I have a small SQL Server 6.5 database running on NT Workstation. From my workstation I can ping that machine and I can map a drive to that machine.

Question: I want to use Union to union two different tables, but they are in different databases. An error message told me that I can’t use Union in this way.

Question: I have a simple query using an SQL statement for returning matching records from an IIS Web server using ASP. I need a new query which returns a match

If you are developing COM components that run under MTS (Microsoft Transaction Server), you will notice that many times your transaction automatically gets aborted. You can easily avoid this situation

The Visual InterDev Scripting Object Model (SOM) offers many time saving techniques for coding Web pages and remote scripting. However, you can lose a lot of time when the finicky

The import directive in Java can sometimes be confusing. For example, if you put this line at the top of your source file: import java.util.*; Do all the classes in

Question: I just want to know where Java came from. Can you give me a history of this language? Answer: I can give you a brief history. Java started out

Question: I just wanted to know if you could share some techniques on how to optimize SQL queries (for example, inner join first before performing some steps, do not use

Question: How can I detect that a window has been resized?I can detect events such as WindowIconified,WindowDeiconified, WindowOpening, WindowClosing, etc., but not the resize event. Answer: Figuring out how to

Question: Every time I try to compile a program, I get “Error(0) Duplicate Resources” and the program stops. I understand that this is a linker error of some kind, but