devxlogo

July 15, 1999

Reporting duplicates

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

Identity?

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

Generate Numbers

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

Finding the Latest Date in SQL

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

Auto assigning primary key values

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

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.

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.

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