difference between sql server2000 and sql server2005

Advertise your Business Here

Refer this Site

Login | Sign Up


	Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff HERE

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

difference between sql server2000 and sql server2005

Question Submitted By :: Singhvijay82

I also faced this Question!!

Rank

Answer Posted By

Re: difference between sql server2000 and sql server2005

Answer
# 1

1.SQL Server 2005 has better tool enhancements like SQL 
Server Management Studio.
2.Developers can write Native .NET Stored Procedures and 
deploy them to SQL Server 2005. 
3.It has more Enhancements in the areas of DBA, Developer 
Productivity with .NET 

For More details..Verify these links..
http://wiki.answers.com/Q/Diff_between_sql_server_2000_and_s
ql_server_2005
http://techinterviewquestion.blogspot.com/2008/06/some-
difference-between-sql-server-2000.html

Is This Answer Correct ?

4 Yes

0 No

Rajkumar

Question	Asked @	Answers
Other SQL Server Interview Questions


I have to display ten columns values from diffrent ten tables. how many joins are require?	HCL	8
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?		3
Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.	Value-Labs	4
wat is the main diff between sql server 2000and sql server 2005	Jade-Software	6
How do you find the number of rows in a table?		5
how to retrive only second row from table in sql server 2000?	CTS	7
What is the difference between a local and a global variable?		3
How can you get @@error and @@rowcount at the same time?		5
what is web server?	Satyam	3
What is INTVAL( )and where we use Plz any body help me		1
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?		2
what is for foreign key ??	Sabic	3
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?		2
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L		4
how can u select the Distinct values in the table, table having 20 columns , i want all columns		1
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?		3
what is curser.		8
what is the importence of the trigger in sqlserver2000?	ATI	1
what is Constraint? How many types of constraints in SQL ?	NIIT	7
About types of indexes in SQL server ?	Cognizent	1

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com