Search:

Rowid is not there in Sql Server 2000.
Rowid can be used in Oracle only.

Do not get confused.

We can delete the duplicate records by using having clause.

In sql serer 2000 in each of the databases there are

.mdf and .ldf

You can have a copy for each of the databases.Ex 1a,1b,2a,2b..............

When ever you want you can load these files to...

It is simple..............

Select * from tablename;

delete from tablename;

Rollback;

Thank you very much.
The link is very useful and very much informative.

Hi all,

What is the differences between
DBMS
RDBMS
ORDBMS


and the advantages and disadvantages also,