Tip Bank

Question: I need your assistance to solve the following: I am using an RDO connection to connect to a SQL 7.0 database, and I am using the server-side cursor technique

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

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

Question: From a previous version of SQL Server 7.0 I saved only contract_Data.MDF and contract_Log.LDF. How can I insert this file in my current SQL Server 7.0? Answer: Here are

Question: How can I get Exchange to forward e-mail to an AOL or ATT account automatically? We have traveling users who have AOL or ATT accounts and would like all

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

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

Question: I am a student. Is there a way to load a database into Oracle to run my exercises? Answer: I’m not sure I can help you because there’s more

Question: How can I get the number of records returned by a query without cycling through all the records and counting each one? Answer: Have you tried SELECT COUNT(*) FROM