June 25, 1998

SQL Database setup

Question: I am writing a CGI program to query an SQL database for a client’s information. I will then create a Microsoft Access database from this querry to pass to

Arithmetic functions in SQL

Question: How do you create or access arithmetic functions like INT, MOD, or SQRT for use in Microsoft SQL Server? Answer: SQL Server supports math functions including SQRT, CEIL, FLOOR,

Descending index on SQL

Question: How can I create an index in descending order? How can I order data in descending order with “Order By”? I’m using MS SQL Server 6.5. Answer: When you


Question: I have a table with three columns. The first, an integer type, is the primary key that is automatically increased by one every time a new row is inserted.