Limit Your Resultset with TOP or SET ROWCOUNT
ou’re probably familiar with the typical “SELECT * FROM Table” SQL statement, which returns all the records in a table. By adding a WHERE clause to a SELECT statement, you
ou’re probably familiar with the typical “SELECT * FROM Table” SQL statement, which returns all the records in a table. By adding a WHERE clause to a SELECT statement, you
lthough Java syntax borrowed heavily from C++, there are many C++ featuresthat Java chose to omit. At times, the lack of a particular featuremakes Java programs cumbersome to implement. One
his is the first of a series of articles on Visual Basic 7.0; now known as Visual Basic.NET. It is well known that VB in its new reincarnation is undergoing
n last month’s 10-Minute Solution, we looked at how to use the OLE automation stored procedures that come with SQL Server to call an object’s properties. These extended stored procedures
ast month, we saw how we could use the Tabular Data Control (TDC) to display recordset data in a paged fashion in Internet Explorer. The TDC is useful when you
n Part I of this article, we built our basic form for our text editor and wrote the Save functionality. In this part, we complete the File menu with the
f you have been following my previous articles, you’ve seen how to display recordset data in a paged fashion using a couple of different techniques. The first article, “Display Recordset
QL Server comes with a powerful language called Transact-SQL (T-SQL) for writing queries and stored procedures. T-SQL is a full-featured language. Like any programming language, it has command statements, conditional
n answering questions for Ask the VB Pro, I’ve been noticing a lot of the same types of questions. These questions primarily relate to basic operations like opening and writing