devxlogo

Tip Bank

Cascade Delete

Question: What is the syntax for doing a cascade delete in SQL? For instance, I have a table with a parent record that has child records in other tables, filtering

Other tools besides BCP

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

How to read data file into SQL tables

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

Passing Arguments to a JavaScript Function

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

About tables

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

Connection

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.

Searching for matching strings

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

How to use Union on two databases?

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.