SQL - Structure Query Language Syntaxes and References

ArticlesVideosBlogsBook ChaptersDownloadsResourcesTutorials

Articles

Sorted by:

Cursor and XML Strore Procedure in SQL by sanju on Nov 10, 2009
How to used Cursor and XML together in SQL Strored Procedures.

Working with SQL Server Logins by Mohammad Elsheimy on Oct 23, 2009
Learn how to work with logins in SQL Server programmatically and via SQL Server Management Studio.

Views in SQL Server 2005 by Erode Senthilkumar on Oct 13, 2009
This article explains about the views in sql server 2005 with sample sql queries.

Working with SQL Server BLOB Data in .NET by Mohammad Elsheimy on Oct 06, 2009
In this article learn how to store and retrieve binary data in a SQL Server or Access 2007 databases.

Differences between procedures and functions by Erode Senthilkumar on Sep 12, 2009
This article will explain difference between functions and stored procedures used in SQL.

Stored Procedures by Puran Mehra on Aug 13, 2009
In this article I will explain you about stored procedure. How to create, execute and alter stored procedure. Why to use stored procedures and advantages of stored procedures.

Openxml - XML Integration with SQL Server by Rekha Singh on Jul 21, 2009
In this article we will know about Openxml and how to perform operation using it.

XML Data type in Microsoft SQL Server 2005 by Ratnesh Singh on Apr 15, 2009
In this article we will see about XML data type in Microsoft SQL Server 2005.

Create a SQL Server CE database from SQL schema file by John Charles Olamendy on Mar 04, 2009
In this article, I will explain how to create a SQL Server CE .sdf database file from a database schema defined in .sql scripts.

SQL Server - FAQ's by Shivprasad on Mar 02, 2009
In this article we will go through the most basic and frequently asked interview questions on SQL Server.

Weird thing with inner queries in SQL SERVER 2005 by Virendra Dugar on Feb 19, 2009
This articles helps you in understand that how inner queries works with relation to outer queries and what problems it can create if not used in proper manner.

SQL Server Compact and LINQ by John Charles Olamendy on Feb 16, 2009
In this article, I will cover how to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ.

Distributed Database Management Systems by John Charles Olamendy on Dec 18, 2008
I’m going to illustrate the principles of Distributed Database Management Systems through this article.

Performance Tuning in Database Systems by John Charles Olamendy on Nov 07, 2008
In this article, we’re going to learn the principles and techniques you can use to help troubleshoot and evaluate query performance by illustrating examples in Microsoft SQL Server and Oracle database.

Materialized Views in Database Systems by John Charles Olamendy on Oct 31, 2008
This article is intended to illustrate the concepts of materialized views in database systems and their realization through examples written for SQL Server and Oracle database systems.

Security in Database Systems by John Charles Olamendy on Oct 23, 2008
In this article, I will cover the principles concerning security and its realization in Oracle database and Microsoft SQL Server.

Indexing for performance in Database Systems by John Charles Olamendy on Oct 20, 2008
In this article, I will cover the different types of indexes in Database Systems such as Oracle and SQL Server.

Simulating autonomous transactions in Microsoft SQL Server by John Charles Olamendy on Oct 10, 2008
In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server.

Physical data organization and indexing by John Charles Olamendy on Oct 07, 2008
This article is intended to explain the main storage structures used in database systems through examples in Microsoft SQL Server and Oracle Database.

Create, Delete, and Update Triggers in a Database by Shashi Ray on Oct 02, 2008
This article discusses how to create and manage triggers in a database using SQL.

Joins in SQL Server 2005 by Raj Kumar on Oct 02, 2008
This article discusses how to use Joins in SQL Server 2005.

Creating and working with Views in a Database by Shashi Ray on Oct 02, 2008
This article discusses how to create, update, and delete views in a database using SQL.

How to use the EXCEPT and INTERSECT operators in SQL Server 2005 by Raj Kumar on Sep 28, 2008
This sample shows how to use EXCEPT and INTERSECT operators in SQL Server 2005.

Understanding Database Stored Procedures by Shashi Ray on Sep 26, 2008
This article discusses basics of stored procedures and how to create, update, and delete stored procedures in a database.


1 - 24 of 24		1