Many people are using databases but they actually don’t have an understanding of the difference between static and dynamic SQL. Their purpose is to get the output of the query either it is static or dynamic. In this article, you will learn about static vs dynamic SQL queries...

Transactional control commands allow users to manipulate various transactions in maintaining database integrity. In SQL, transactions begin when applications are executed. The very first transaction is started at the onset of the SQL application, while the last transaction is ended when the application...

What is a primary key?

Constraints enable the RDBMS enforce the integrity of the database automatically, without needing you to create triggers, rule or defaults.

Types of constraints: NOT NULL, CHECK, UNIQUE, PRIMARY KEY, FOREIGN KEY

For an explanation of these constraints see books online for...

DELETE TABLE is a logged operation, so the deletion of each row gets logged in the transaction log, which makes it slow. TRUNCATE TABLE also deletes all the rows in a table, but it will not log the deletion of each row, instead it logs the de-allocation of the data pages of the table, which makes it...

What is a Table in a database ?

A join created by joining two or more instances of a same table.
Query: Select A.firstname ,B.firstname
from t_employee A, t_employee B
where A.supervisor_id = B.employee_id;

Inner join
outer join
left outer join
right outer join
full outer join
inner join

It is very common to want to associate a date and/or time with a row’s worth of data. For instance, your table rows might represent requests made by your Web site users, and the associated date/time is the time that that request hit your database.

Now, one way to insert or update date fields...

Managed extensibility framework (MEF) is a new library that is introduced as a part of .NET 4.0 and Silverlight 4. It helps in extending your application by providing greater reuse of applications and components. MEF provides a way for host application to consume external extensions without any configuration...

The new HIERARCHYID data type in SQL Server 2008 is a system-supplied CLRUDT that can be useful for storing and manipulating hierarchies. It is internally stored as a VARBINARY that represents the position of the current node in the hierarchy. You can create indexes,...

Database systems are designed to manage large bodies of information. These large bodies of information do not exist in isolation. They are part of the operation of some enterprise whose end product may be information from the database or may be some device or service for which the database plays only...

ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes

Hi,
I know little bit sql. I want to know about Inner join and outer join. And what is the difference between ?