Posts

Showing posts from February, 2014

Torrents Sites Listing

http://thepiratebay.se/ http://pimp4003.net/ http://kickass.to/ http://extratorrent.cc/ http://glotorrents.com/ http://divxhunt.me/

Android Setup Download

Download Android SDK http://developer.android.com/sdk/index.html Download Java Development Kit http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

Constraint Example

NOTNULL:- CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255) ) UNIQUE:- CREATE TABLE Persons ( P_Id int NOT NULL UNIQUE, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255) ) PRIMARY KEY:- CREATE TABLE Persons ( P_Id int NOT NULL PRIMARY KEY, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255) ) FOREIGN KEY:- CREATE TABLE Orders ( O_Id int NOT NULL PRIMARY KEY, OrderNo int NOT NULL, P_Id int FOREIGN KEY REFERENCES Persons(P_Id) ) CHECK:- CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), CHECK (P_Id>0) ) DEFAULT:- CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255) DEFAULT 'Sandnes' )