1.1.   Constraints Constraints allow you to define the way Microsoft® SQL Server™ 2000 automatically enforces the integrity of a database. Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. Using constraints is preferred to using triggers, rules, and defaults. The query optimizer also uses constraint definitions to build high-performance query execution plans. 1.1.1.                  Classes of Constraints SQL Server 2000 supports five classes of constraints. NOT NULL specifies [...]

1.      SQL Server 2000 Reading Material This reading material is intended to provide basic knowledge in SQL Server 2000 for the testers. 1.1.   Database Normalization Basics If you’ve been working with databases for a while, chances are you’ve heard the term normalization. Perhaps someone’s asked you “Is that database normalized?” or “Is that in BCNF?” All too often, the reply is “Uh, yeah.” Normalization is often brushed aside as a luxury that only academics have [...]

Beginning Visual C# .NET 1. Your First Visual C# .NET Project Review and Preview: In the first class, you learned about forms, controls, properties, and event methods.  In this class, you’re going to put that knowledge to work in building your first simple Visual C# .NET project.  You’ll learn the steps in building a project, how to put controls on a form, how to set properties for those controls, and how to write your own [...]

WCF Tutorial: Windows Communication Foundation (WCF) is an extension of .NET framework to build and run the connected systems. Windows Communication Foundation provides a unified framework for building secure and reliable transacted Web services. Windows Communication Foundation combines and extends the capabilities of Distributed Systems, Microsoft .Net Remoting, Web Services, Web Services Enhancements (WSE), to develop and deliver unified secured systems. WCF framework builds the loosely-coupled applications on service oriented architecture that interoperate more securely [...]

Hey This is the first part of C#.net Tutorial of  four parts, and further parts will be updated soon….. Beginning Visual C# .NET 1. The Visual C# .NET Design Environment Parts of a Visual C# .NET Project: In Class 1, we saw that there are four major components in a Visual C# .NET application:  the solution, the project, the form, and the controls.  A solution can contain multiple projects.  In this course, solutions will only [...]

The Object Oriented Features Of C++ INTRODUCTION OBJECT Object is a concept, abstraction, or thing with crisp boundaries and meaning for the problem at hand .Objects serves two purposes: they promote understanding of the real world and provide a practical basis for computer implementation. Decomposition of a problem in to objects depends on judgment and nature of the problem. All objects have identity and are distinguishable .Two apples with the same colour, shape, and texture [...]

Search Engine Optimization: How do you make your web site gain rank in search engine listings? Search Engine Optimization (SEO) is the word you’re looking for. Search engine’s don’t see pages the same way we doe, there’s no color, no flash, no pizzaz that makes them go “this is a professional page” – you have to make it know what the page is about, and SEO makes sure the search engine sees your page the [...]