sql | SQL

Use of DISTINCT clause
Use of DISTINCT clause In table, some of the columns may contain duplicate values. Sometimes you will want to list only the different (distinct) values in a table. The DISTINCT claus......

Posted in: SQL | By: rekha singh | Date: 29 Apr 2010 11:14 am | Comments (0)

The DELETE statement
The DELETE Statement The DELETE statement is used to delete rows in a table. ========================================================== SQL DELETE Syntax DELETE FROM table_name WH......

Posted in: SQL | By: rekha singh | Date: 28 Apr 2010 12:59 pm | Comments (0)

The UPDATE statement
The UPDATE statement The UPDATE statement is used to update records in a table. Syntax UPDATE table_name SET column1=value, column2=value2,... ......

Posted in: SQL | By: rekha singh | Date: 28 Apr 2010 1:03 pm | Comments (0)

Simple insert Query
Simple insert Query insert into <Table Name> <fileld name>values<field value> Insert into sqldemo (id,password,status) values('sds','sad','sdsa'); Insert int......

Posted in: SQL | By: rekha singh | Date: 28 Apr 2010 1:07 pm | Comments (0)

Logical AND Operator
Logical AND Operator The AND operator displays a record if both the first condition and the second condition is true. It can be used in any valid SQL statement such as select,insert,up......

Posted in: SQL | By: rekha singh | Date: 28 Apr 2010 1:10 pm | Comments (0)

Simple SQL SELECT Statement
SQL SELECT Statement The SELECT statement is used to select data (THROUGH WHICH WE CAN GET DETAIL) from a database. The result is stored in a result table, called the result-......

Posted in: SQL | By: rekha singh | Date: 29 Apr 2010 11:08 am | Comments (0)

Simple Insert data using(DATA SET) ds and dt
Save button event protected void btn_save_Click(object sender, EventArgs e) { first f =......

Posted in: SQL | By: rekha singh | Date: 29 Apr 2010 11:36 am | Comments (0)

Database Management System
Database Management System Database management system are used when large quantities of data that needs to be tracked in an organization. Classical paper based data management systems cau......

Posted in: SQL | By: rekha singh | Date: 29 Apr 2010 12:18 pm | Comments (0)

Stored Procedure Help
I am creating a stored procedure (basic knowledge of sps on my part) and when I try to execute this sp I get an error message. I'm not sure what is wrong with it and how to fix it. Any idea's anyone? ......

Posted in: SQL | By: rekha singh | Date: 07 May 2010 4:29 pm | Comments (4)