SQL Blogs

SQL

Learn SQL, a language to query and manipulate relational database management systems.

Blogs

Difference between delete and truncate.

This blog shows the difference between Delete and Truncate.
Vishal Nayan Apr 30, 2011
Converting 0 to 1 and 1 to 0 in a SQL Server Table

Converting 0 to 1 and 1 to 0 in a SQL Server Table
Venkatesan Jayakantham Apr 30, 2011
Concatenate row data into a single data in SQL Server

Concatenate row data into a single data in SQL Server
Venkatesan Jayakantham Apr 30, 2011
Difference between Truncate and Delete

Difference between Truncate and Delete
Venkatesan Jayakantham Apr 30, 2011
SQL: CROSS JOIN

Cross join is used to return all records where each row from first table is combined with each row in second table.
Nipun Tomar Apr 27, 2011
SQL: Wildcard Operators

SQL wildcards can substitute for one or more characters when searching for data in a database
Nipun Tomar Apr 27, 2011
SQL: Types of Cursors

Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis
Nipun Tomar Apr 27, 2011
SQL: Tips to increase the SQL performance

Here are the several tips to increase the performance of your SQL:
Nipun Tomar Apr 27, 2011
Distributed Database Management System

Introduction to Distributed Database Management System
Venkatesan Jayakantham Apr 26, 2011
Identity Functions

In this blog you will see Identity Functions.
Mayur Gujrathi Apr 26, 2011
SQL: UNION V/S UNION ALL

In SQL Server, by using UNION and UNION ALL we can combine multiple datasets into one comprehensive dataset.
Nipun Tomar Apr 26, 2011
combining column names in sql server

combining column names in sql server
Venkatesan Jayakantham Apr 22, 2011
Constraints on the whole table in SQL Server

Constraints on the whole table in SQL Server
Venkatesan Jayakantham Apr 22, 2011
Varchar to Float in SQL Server

Varchar to Float in SQL Server
Venkatesan Jayakantham Apr 22, 2011
SQL Server User Group meet @ Chennai

SQL Server User Group meet @ Chennai
Venkatesan Jayakantham Apr 22, 2011
CHAR function in SQL Server

CHAR function in SQL Server
Venkatesan Jayakantham Apr 22, 2011
Replace function in SQL Server

Replace function in SQL Server
Venkatesan Jayakantham Apr 22, 2011
Changing the path of the MDF and LDF file for the database

Changing the path of the MDF and LDF file for the database
Venkatesan Jayakantham Apr 22, 2011
Some inbuilt functions in SQL Server

Some inbuilt functions in SQL Server
Venkatesan Jayakantham Apr 22, 2011
SQL Cache dependency

SQL Cache dependency
Venkatesan Jayakantham Apr 22, 2011

421 - 440 of 498