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

How can I create a report based on a query? : sql server management studio

979


What is explicit cursors?

1000


What is a ddl statement?

861


What is the need for group functions in sql?

1022


What is collation sensitivity?

996


Explain what are commit and rollback in sql?

872


What is db stored procedure?

820


What is the default sql server instance name?

988


What is table-valued sub query?

928


How to send a ssrs report from ssis?

168


How sql server executes a statement with nested subqueries?

976


What is the simplest way to create a new database in ms sql server?

970


What is inner join? Explain with an example?

1126


What the difference between UNION and UNIONALL?

995


Tell me what is a linked server?

997