SQL

Detecting and Deleting Duplicate Records in SQL Server 2005 and Above

Submitted by tamizhventhan on
Most of the time, we encounter duplicate records in our database. And it's not easy to delete it if you don't have enough knowledge about SQL Statement. This code will help you detect and delete duplicate records in SQL Server 2005 and above. (These commands only works on sql server 2005 or higher) Create table create table example(id int identity(1,1),name varchar(20),class varchar(20)); (Here

Don’t Limit On SQL for Database Computing in Java Development

Submitted by Raqsoft on

During Java development, SQL is often used to address the database related computation. However, "Ordered Computation" is very inconvenient to realize by writing SQL statements. For example, according to Contract table, compute the monthly growth rate of contract values for each sales man in a specified period. The result set of SQL follows a weird convention that the result set returned directly

Airline Reservation System V1.0

Submitted by Raj.Sharma on
username- admin password- 12345 password change option is available...Crystal reports and Printing Datagridview r added n all kinda validations are added note: it will not work properly in visual studio express edition or limited edition enjoy....... For students or anyone else who needs program or source code for thesis writing or any Professional Software Development,Website Development,Mobile

Student Book X Upgrade(Sql server 2008 R2)

Submitted by Jazziro on

*Student Book X (Upgrade) v1.9.0.1.1 *Created by: Jazziro/Lehlogonolo Masubelele *Description: Student Book X is an Application that can help niversity/college students store very important contact details of their friends, users can view, edit or delete records. *Easy way to Connect to MS SQL SERVER 2008 R2 with VS 2005. *Easy way to learn SQL Statements: SELECT(Like Conditions), INSERT, UPDATE

MS Access 2010/2007 database to manage SQL Server scripts

Submitted by magicscreen on
This application allows the user to manage SQL Server scripts. It also allows the user to place SQL Server .SQL scripts in a "Run Once" Windows folder or in a general "Run Whenever" Windows folder. The scripts can be prioritized so they run in a specific order, if necessary. The program works with Windows Logon as well as SQL Server Logon.
Subscribe to SQL