What are the differences between FoxPro and MS SQL Server?

You can use SELECT command for performaing single as well as complax operations depending on requirements.Belo is a simple use of SQL statement for getting duplicate records from database table:-

SELECT *
FROM `<table>`
WHERE  <key>
IN (

SELECT <key>
FROM  <table>
GROUP BY <key>
HAVING count( * ) >1
)
 

Example:-

SELECT *
FROM `demo`
WHERE id
IN (

SELECT id
FROM demo
GROUP BY id
HAVING count( * ) >1
)

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query languages are MS-SQL and T-SQL.

Many times in ASP or dot net we may need to connect to a mysql database.For making a connection to mysql database we need to install mysql connector for windows which you can download from:-

Sql server provides many error codes if you are using sql server as a developer or as a administrator then

you must be familiar with error code that what they mean.Below is list of error codes which i have collectaed.

These error codes can help you a lot in sql server management and administration.

Number

Severity

Text and Explanation   Login or register to post comments Read more

Indiapoly Members Pramod anita thakur Rohit Sharma indiapoly deepakvirus veer   Join Now Our Parters http://inderweb.com http://indersingh.com http://shikarimata.com http://himalayansky.com http://doeaccnews.info http://blog.indiapoly.com http://merevichar.com   Contact us to Join Our Partner List....