Advantages of sql 2000 over sql 7.0, DOT NET Programming

Assignment Help:

What are advantages of SQL 2000 over SQl 7.0?

1)User-Defined Functions: The User-Defined Functions (UDFs) -- one or moreTransact-SQL statements may be used to encapsulate the code for reuse. The Userdefinedfunctions cannot make a permanent change to the data or modifythe database tables. The UDF can change only the local objects for a UDF, like local cursors or variables.

2)Distributed Partitioned Views: The Distributed partitioned views allow you topartition the tables horizontally across the multiple servers. Therefore, you can scale out onedatabase server to a group of database servers that cooperate to provide thesame performance levels as a cluster of database servers. Due to the distributed partitioned views, the SQL Server 2000 now on the first place in the tpc-c tests.

3)New Data Types: This include: bigint, sql_variant,an 8-byte integer type;  a data type that allows the storage of data of different data types; and the table  data type, which allows all applications to store the results temporarily for later use.

4)INSTEAD OF and AFTER Triggers: There are INSTEAD OF & AFTER Triggers in the SQL Server 2000. INSTEAD  triggers are executed instead of the INSERT,DELETE , UPDATE or triggering action. AFTER triggers are executed after the triggering action.

5)Cascading Referential Integrity Constraints: These are new ON DELETE & ON UPDATE clauses in the REFERENCES clause of the CREATE TABLE and ALTER TABLE statements. The ON DELETE clause controls what actions are taken if you attempt to delete a row to that existing foreign keys point. The ON UPDATE clause defines the actions that are taken if you attempt to update a candidate key value to which existing foreign keys point.

The ON DELETE and ON UPDATE clauses have 2 options:

NO ACTION :-The NO ACTION specifies that the deletion/update fail with an error.

CASCADE :-The CASCADE specifies that all the rows with foreign keys pointing to the deleted/updated row are also deleted and updated.

6)32 CPU and 64GB Memory Support: The SQL Server 2000 Enterprise Edition running under the Windows 2000 DataCenter can support up to 32 CPUs and up to 64GB of physical memory (RAM) on a computer.

7)XML Support: The SQL Server 2000 can use XML to insert,  delete, and update values in the database, and the database engine can return data as in the Extensible Markup Language (XML) documents.


Related Discussions:- Advantages of sql 2000 over sql 7.0

Difference between convert.tostring and .tostring() method, What is the dif...

What is the difference between Convert.toString and .toString() method To know the difference between Convert.toString and .toString() see the below code : int i =0; Mess

What is extensible markup language, What is Extensible Markup Language (XML...

What is Extensible Markup Language (XML). XML is an easy and flexible mark-up language in the text format. Nowadays, it is widely used to exchange a large variety of data over

Different levels of iis isolation, What are the different levels Of IIS i...

What are the different levels Of IIS isolation?  The IIS consist of 3 level of isolation as shown below:- LOW (IIS process):- In this type of isolation the main IIS proc

What is dbms, What is DBMS? It is a collection of programs that enables...

What is DBMS? It is a collection of programs that enables user to make and maintain a database. In other words it is general-purpose software that gives the users with the proc

Steps involved to fill a dataset, What are the steps involved to fill a dat...

What are the steps involved to fill a dataset ? The sample code is shown below: Private Sub LoadData() Dim strConnectionString As String strConnectionString = AppSetti

Explain how the server control validation controls works, Briefly explain h...

Briefly explain how the server control validation controls work? A validation control works by evaluating the value of an input server control on the page to see whether it mee

Work with me on different coding using visual studio, Work on different cod...

Work on different coding using visual studio 2012/2013 writing Java script as well as C# codes. Project Description: I want to shift to new Programming Env. and I would like

Management, read a file which has emp.no,name,age as per fields/you want to...

read a file which has emp.no,name,age as per fields/you want to calculate no.of employess whose age more than50

I require to syn my microsoft exchange calendar, Google Calendar Project...

Google Calendar Project Description: I require to syn my Microsoft exchange calendar with the Google calendar so i will view the all the changes that happen in Microsoft exch

Explain in brief dataadapter class in ado.net, Explain in brief DataAdapter...

Explain in brief DataAdapter class in ADO.NET. The DataAdapter class retrieves data from the database, keeps data in a dataset, and reflects the changes made in the dataset to

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd