Advantages of sql 2000 over sql 7.0, DOT NET Programming

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.

Posted Date: 9/24/2012 4:14:01 AM | Location : United States







Related Discussions:- Advantages of sql 2000 over sql 7.0, Assignment Help, Ask Question on Advantages of sql 2000 over sql 7.0, Get Answer, Expert's Help, Advantages of sql 2000 over sql 7.0 Discussions

Write discussion on Advantages of sql 2000 over sql 7.0
Your posts are moderated
Related Questions
Question: (a) Define four special target names use with the TARGET attribute. (b) Assume that you have a document with many subsections. Write the HTML code to create a fr

What's difference between "Optimistic" and "Pessimistic" locking? In the pessimistic locking when user wants to update a data it locks the record and till then no one can updat

What are the different types of joins? 1) INNER JOIN: The Inner join shows matches only when they exist in both the tables.For example, in the SQL below there are two tabl

In search of urgent assistance with loading an ASP.net website In search of assistance with loading an ASP.net website installation onto a new server, job will start nearly D

I need very easy project in metatrader Project Description: I have 3 indicators.... ADX, emas crossover and macd crossover! They are all signals, arrows! But i would like to

I require a visual basic (VB) app developer to enhance an existing application. There are very few manual inputs in the application which I need to be imported via excel file. E

The ASP.NET new feature supports are shown below :- Better Language Support 1) The New ADO.NET Concepts have been implemented. 2) The ASP.NET supports complete  language

1. Prepare  a grocery list   having four columns (Serial number, The name of the product, quantity and price)  for the month of April, 06. Font specifications for Title(Groce

Write the basic steps to execute a LINQ query. The following are the three basic steps to execute a LINQ query:     Obtain the data source (The data source can be either an

Project Description: I have a basic C# control interface that I want to be accessed remotely. Possible implementation using wrappers. Skills required are C# Programming, Webs