Data Switch Guide Review

Sql Dataset
If a dataset contains 100 rows, how to fetch rows between 5 and 15 only in SQL?

Give the exact SQL query for this

Hi

If u r using SQL Server 2000, then u can use the below query:

select top 10 * from tblName where colName in (
select top 15(colName) from tblName order by colName asc
) order by colName desc

SQL Server 2005 contains enhancements that can handle such scenarios directly.

Sql Dataset

Microsoft Access Runtime Programs – Powerful Data Solutions On A Budget

There are many considerations to make when trying to decide which program to use to handle various aspects of your business. For the small business on a budget, Microsoft Access Runtime just may very well be the best solution.

Many times small businessess’ are on a tight budget and need to acquire the most for their dollar. One of the aspects that any business needs is some type of database to enable data entry and reporting operations, so they will have immediate access to their data.

There are many various solutions out there. Some of which can cost 10s even 100s of thousands of dollars to implement, which is more than most small businessess’ are looking to spend. A solution to this, which would be able to provide a business with a robust applications that will streamline their operations and be very cost-effective would be a Microsoft Access Runtime program.

An customized program specifically designed for your business not only offeres the advantage of having an application that is completely built around your business, so it will operate at peak efficiency but these advantages:

• Powerful and Robust System
• Cost Effective – Microsoft Access does not need to be installed
• Works flawlessly with the world’s most popular productivity software (Microsoft Office)
• Build completely around your business, which will provide you and your staff with easy access to your data and a complete picture of your business.

These are just some the many advantages that come along with a Microsoft Access Runtime program.

Are there limitations with a Runtime program? Microsoft Access is can not hold the amount of data that large enterprise systems do, however the amount of data that it is able to maintain is more than adequate for most small businessess as well as large corporations who are in need of smaller databases to use within their departments or link to large corporate data structures in order to extract specific datasets.

Other than that, Microsoft Access offers all the flexibility that you would find in the more expensive and larger enterprise systems. As a bonus from my experience, I have found Microsoft Access to work with the Microsoft Access Suite better than any application. This refers to such capabilities as being able to automatically create Word documents, complex Excel charts, graphs, and pivot tables, automated Outlook e-mails etc. Microsoft Access works flawlessly with these programs.

If you are a small business owner or even from a large business looking for a cost-effective solution for your data management that will be built around your business, a Microsoft Access Runtime program may very well be the program to go with.

About the Author

Dan H is the owner of Data Gopher, which is a professional Microsoft Access Development company and is a well respected Access Developer. He has designed Access database solutions for many fortune 500 companies and is an active contributor to the Microsoft Access development community.

I want a query that will select all items in a table not in a current dataset?

Say I have table with 10 rows .. and my data set contains all rows except row 2 and row 7.

If you’re stuck on the looping through the dataset approach, it’s simple enough. Just keep adding a “WHERE.. MYFIELD <> MYVALUE AND..” to the end of your SQL string. Unless you’re working with a pretty small dataset I’m not sure that’s the best approach though.

Would it be possible to invert the statement used to populate your initial dataset? The ultimate solution will depend on what environment you’re working in though.

Data Access VS2010 2 of 5