.NET Mastery: June 2012

6/19/2012

SQL Constraints

Constraints limit the type of data that can go into the table.
The following are the constraints:

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

Hi newbies,
Want to learn SQL joins at a glance!!, here you go... SQL joins is Venn diagram representation:
A very nice picture given in codeproject.

http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

Do you know?

Private class members are inheritable to the base class, but will not be able to access them

RPC,Webservices,REST are principles , they do not belong to any languages .NET, Java,..

The CLR provides the appearance of an application virtual machine so that programers need not consider the capabilities of specific CPU that will execute the program

Static Members and Classes cannot be accessed by instance of a Class (i.e by an object)

DLL's don't get loaded in RAM together with the program , so space is saved in RAM(Random Access Memory)

Interfaces cannot have access modifiers such as public/private..

C# doesn't support Constant Methods,Properties or Events

C# doesn't support multiple inheritance , but by interface.

C# compiler doesn't allow use of uninitialized variable

.NET Mastery

6/19/2012

SQL Constraints

6/18/2012

SQL Joins