You should use single quotes to enclose character strings within Transact-SQL queries when used with MS SQL Server. The advantage is that your queries will work regardless of the QUOTED_IDENTIFIER

Question: I have a char array, for example: char orig_amt [20]. I need to convert this to an int orig_amt so I can do some calculation. Is there a command

Question: As a rule of thumb, a query that does a join will run faster if the table with the least number of rows is referenced first in the FROM-clause

Question: How can I delete more than 1 Item from the listbox at once? Answer: I don’t believe the Windows list box allows you to delete more than one item

Question: I am working on an assignment that asks us to determine why using C++ is a bad choice, from a software engineering perspective.So far, I have found that C++

Question: I have 2 databases in SQL7. I need to attach one table, TB1, from DB1 to DB2, to run a join query. My query uses TB1 from DB1 and

Question: I have a small console program that requires I pass arguments for it to run specific functions. I want to change the code so it automatically runs a set

Question: How do I read in both a character string and int value from a file? The data I am trying to read looks like this: Name1 10 10 10Name2

Question: I have a message box that comes up to warn the user that they are terminating the application as it normally should be left running. I want to know

Question: Visual 6.0 displays an error that says it can’t find one of my libraries, but it is right there in the same folder. Answer: Assuming the libraries are there,

Question: I’m writing a program in Windows 95.I try to READ memory address FFFF:0005 that contain BIOS date, by using peekb(int, int) function, but Windows displays a close message. How

Question: I want to get the member names of a class and their values by names. Is this possible with C++ alone or do I need a tool for this?

Question: I have a pbl which gives gpf’s when I try to open it in PB v6.5. I am able to see some syntax when I view the pbl in

Question: I was wondering how to hide the taskbar in NT/95? Answer: To hide the task bar you will need to declare two API calls. These two API calls will

Question: I know that when using products like Cold Fusion, you can pass parameters to the page that does the work. Example: [*.cfm]. I have been trying to do this

Question: When creating a Datawindow from SyntaxFromSQL function with a group break, the Trailer Group Totals and the Summary Totals get generated with a Format of #,##0.00. I would like

Many computer users, especially power users, prefer keyboard commands instead of the mouse. Accelerator keys are common in compiled applications such as Visual Basic programs, but rare on Web pages.

SQL Server 7.0 includes full Unicode support, which simplifies international localization. N is the Transact SQL (T-SQL) shorthand that tells SQL Server you’re referencing a Unicode string. In this example,

Java 1.1 introduced the java.awt.datatransfer package and its associated classes, which provide the foundation for capabilities such as cut-and-paste. On the surface, the API may appear complex, but this simple

The long long type denotes an integral data type that is at least as large as a long int. On 32-bit architectures and 64-bit architectures, long long occupies 64 bits

The order of evaluation of function arguments is unspecified. This means that for a function that takes the arguments (a, b, c), any permutation of this set is a valid

The ANSI/ISO C++ Standard is now available for downloading from the NCITS (National Committee for Information Technology Standards) Web site at http://www.cssinfo.com/ncitsgate.html. The downloadable PDF format costs $18. Note that

When working on developing or debugging an app created by automation (for example, by ActiveX DLL), if you normally invoke that app from a calling program (EXE), leave the calling

Have you ever wondered why your ActiveX DLL with a form doesn’t show up in the taskbar? Because you’re showing the form modally (.Show vbModal). VB4 only allows DLLs with

Question: Are there any tools coming with SQL Server 7.0 for this migration from FOCUS 6.0? If not, what is the best way to accomplish this migration? Answer: Yes, DTS

Question: What are business rules in relation to a DBMS. Do you have any posssible examples for a university database? Also: Do you have any hints to drawing a Semantic

Question: I write a statement such as frmStatistics.datStatistics.RecordSource = “SELECT * FROM tblSpecialGroup Where Sex = ‘M’ AND Date BETWEEN ‘” & “051099” & “‘” & ” And ” &

Question: Being new to SQL Server 7.0 I wanted to get other opinions on this: My company has many clients using a proprietary db schema that will replicate transactions to

Question: I’m a beginner VB programmer and am having problems figuring out how to handle events in forms. I have a class that raises an event for each step in

‘ Set a bit in a value” NOTE: requires Power2()Function BitSet(ByVal value As Long, ByVal bit As Long) As Long ‘ simply OR with the bit mask ‘ Range checking