(Joel Murach) In this seventh part of a nine-part series, you will learn how to use the IN and BETWEEN operators, along with the SELECT statement, to retrieve data from a single table.
Other News
Meet special guest speaker & author Michael Lewis at IOD11
(Susan Visser) Have you heard that one of the special guest speakers at the IBM Information on Demand Conference this year is Michael Lewis? Personally I hadn’t hear of Michael before he was signed to speak at the conference, but once I looked him up, I realized that I knew his work.
TreeView Control Populating with SqlDataSource
(Mayur Dighe) The article demonstrates how to populate TreeView Control using SqlDataSource at runtime in C#.NET. We can achieve intended result by simply executing SqlCommand Object either by ExecuteReader or ExecuteNonQuery method.
Getting Started with Schematron
(ToniMaroni) This article takes the first example of the excellent Schematron tutorial available here and shows how to create the XML input, the .sch Schematron schema file and how to instantly validate it all in Altova’s XMLSpy® XML editor and the “XML ValidatorBuddy” plugin. Once you have seen how
SQL Server Denali Server Side Paging
(Arshad Ali) When designing a User Interface (UI) you normally display 10, 20, 50 or 100 rows on the screen for readability purposes and easy navigation. One way to do this, is to bring all the data from SQL Server to local memory and do the navigation locally.
Experimenting With A Stateful Class For Stateful User Interface (UI) Widgets
(Ben Nadel) After going back and forth with Dan G. Switzer, II in the comments of my blog post on Finite State Machines and UI widgets, I wanted to try and factor out the “stateful” aspects of my code into some sort of reusable, lightweight framework.
Using sp_repldone to SKIP a transaction
(Chris Skorlinski) The steps in this posting covered advanced topics is SQL Server Transactional Replication. If you are unsure on how or when to use these steps, DON’T, instead contact Microsoft SQL Server Support or post your problem on the TechNet forum/newsgroup. These steps will result in dat
Proactively Controlling ADF Query Execution with Estimated Row Count
(Andrejus Baranovskis) In ADF BC we can configure how many rows VO should return, however in the background it still will execute entire SQL statement without attaching rownum < X to it. We can prevent this by overriding executeQueryForCollection method and checking estimated row count, before invok
DB2 Symposium 2011 – Round Two
(Craig S. Mullins) Today’s blog post is about the DB2 Symposium, a three day training event with one day seminars presented by well-known DB2 consultants.
How to Restore Corrupt MySQL Database Tables
(Mark Willium) MySQL database is a registered product of sun Microsystems. It is platform independent in nature that means a database administrator can install MySQL database on different operating systems like windows, Linux, and others.