Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is advantages in sql 2005 over sql 2000?

Answer Posted / subbu

Newly introduced in Sql server 2005
======================================
DDL trigger (This trigger fired only create new table or
Drop table or Alter table).Created in either Database or
Server.
To Deploy .Net procedures.
CLR Integration.
TRY & CATCH Mehod (For Error Handling).

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is factless fact table? : sql server analysis services, ssas

975


Can you leave a union at any time?

1015


what is the difference between count(*) and count(1) ?

1032


Does sql server use t sql?

962


Difference between 2NF &3NF ?

1036


What is a dataset and what are the different types of datasets?

129


Explain user defined views?

915


What is sharding?

116


what authentication modes does sql server support? : Sql server database administration

1014


What is difference between delete and truncate commands?

1011


What is database white box testing?

1086


Can we check locks in database? If so, how can we do this lock check?

897


Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

864


Explain sql delete command?

1010


What is the difference between Stored Procedures and triggers?

1041