Last Uploaded Images |
 |
marry_christmas_from_ashok_sahu_2012....
Views:204
|
 |
marry_christmas_from_ashok_sahu_2012....
Views:100
|
 |
marry_christmas_from_ashok_sahu_2012....
Views:102
|
 |
Remember-Time....
Views:206
|
 |
Shiv....
Views:865
|
|
|
|
|
What do you have to say...... | |
|
| | Bloggers:5706 Posts:88432 Today:6 Posts
| |
|
|
 |
The SQL CHECK CONSTRAINT ensures that a value for a
specific column or columns have satisfied a specified
condition.
The job of CHECK constraint is, to limit the values for a
column of a table. ....
Read Full Post On Blogs
 W3resource at 03:17:50 PM 6th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
The SQL FOREIGN KEY CONSTRAINT is used to ensure the
referential integrity of the data in one table to match
values in another table.
The FOREIGN KEY CONSTRAINT is a column or list of columns
which points to the PRIMARY KEY of another table. ....
Read Full Post On Blogs
W3resource at 03:15:36 PM 6th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
The SQL PRIMARY KEY is a column in a table which must
contain a unique value which can be used to identify each
and every row of a table uniquely.
However, SQL supports primary keys directly with the PRIMARY
KEY constraint. ....
Read Full Post On Blogs
W3resource at 03:14:09 PM 6th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
The SQL UNIQUE constraint is used to ensure that the each
rows for a column have different value. In this page we are
going to discuss, how the SQL UNIQUE CONSTRAINT works if it
is used at the end of the CREATE TABLE statement instead of
using the UNIQUE CONSTRAINT....
Read Full Post On Blogs
W3resource at 03:12:40 PM 6th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
The SQL CONSTRAINTS are an integrity which defines some
conditions that restricts the column to remain true while
inserting or updating or deleting data in the column.
Constraints can be specified when the table created first
with CREATE TABLE statement or at the time of modification
of structure of an....
Read Full Post On Blogs
W3resource at 03:11:10 PM 6th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
Tables are a basic unit of organization and storage of data
in SQL. Each table has an name such as a author, book_mast,
purchase or orders. A table is similar to a file in a
non-database system.
....
Read Full Post On Blogs
W3resource at 03:09:25 PM 6th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
In Sql, the create database statement is used to create a
database.
The database names are case sensitive in Unix but this
restriction does not apply in Windows. This is also true for
table names. The best practice is to use same letter case
while creating database as well as tables.....
Read Full Post On Blogs
W3resource at 11:56:52 AM 4th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
The FULL OUTER JOIN will return all rows, as long as
there's matching data in one of the tables. It includes all
the rows from both the participating tables and does not
select either the LEFT or RIGHT table from the JOIN key
word. ....
Read Full Post On Blogs
W3resource at 11:55:16 AM 4th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
The SQL Right Join or simply RIGHT JOIN return all rows
from the first table listed after the JOIN keyword , no
matter if they have matches in the left table of the JOIN
keyword.
This means that if the ON clause matches no records in the
left table of JOIN....
Read Full Post On Blogs
W3resource at 11:53:52 AM 4th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
The SQL Left Join or simply LEFT JOIN return all rows from
the first table listed after the FROM clause or left of JOIN
keyword , no matter if they have matches in the right table
of the JOIN keyword.
This means that if the ON clause matches no records in....
Read Full Post On Blogs
W3resource at 11:51:57 AM 4th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
SQL INNER JOIN returns all rows from tables where the key
record of one table is equal to the key records of another
table.
The INNER JOIN may be called an EQUI JOIN. ....
Read Full Post On Blogs
W3resource at 11:50:16 AM 4th February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
The SQL BETWEEN operator tests an expression against a
range. The range consists of a beginning, followed by an AND
keyword and an end expression. The operator returns 1 when
the search value present within the range otherwise returns
0.
http://bit.ly/w8O2cM
....
Read Full Post On Blogs
W3resource at 04:10:32 PM 3rd February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
The IN operator checks a value within a set of values
separated by commas and retrieve the rows from the table
which are matching. The IN returns 1 when the search value
present within the range other wise returns 0.
http://bit.ly/whMu7b
....
Read Full Post On Blogs
W3resource at 04:07:01 PM 3rd February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
|
|
Once there is some data in the table, it may be required to
modify the data. To do so, the SQL UPDATE command can be
used. It changes the records in tables.
http://bit.ly/AhRVf3
....
Read Full Post On Blogs
W3resource at 04:05:17 PM 3rd February 2012 QUICK COMMENT|COMMENTS(0)
|
|
|
|
|
|
|
1 2 3 4 5 6 >>>
|
|
|
