October 8, 1999

Parameter Setting

Question: I need to know how to write SQL to ask for a date range and run the query on that range. Can you help me? Answer: I think it

Moving a SQL Database to Another Server

Question: I have a SQL database on our production NT server and need to move the database to another NT server. I used the Database/object transfer in Enterprise Manager to

Training Management Companies

Question: I am with a large Fortune 500 company looking for a training management solution to produce CBT courses, organize, and report on skill-based courses and instructor-led courses on our

Creating a Database from Access

Question: I just installed SQL 7 on my server and have an Access database that contains a lot of information. How do I create a SQL database? Also, is there

Difference Between Two Dates

Question: What is the difference between two dates, date1 and date2, when date2 is in the next record? Answer: Use this code: select datediff(laterone.date1, earlierone.date1) from table earlierone, table lateronewhere

Losing Decimal Places While Updating a Column

Question: I have two columns in a table called “bak”: distance, and trig. The distance value is equal to 1/trig. When I perform the following query: update bakset distance =