what is the difference between sql 2000 and 2005?
Answer Posted / khv11in
In sql server2000 Extended Stored procedures , and it
modified it into CLR Stored procedures
1.sql server 2005 include interprise manger and query
analyser together in same window we can open many window
tabs in same place but in 2000 it is in different.
2. sql server 2005 support more new datatype like xml
3. we can make more database 2(paw(20))-1 in 2005 in compare
to 2000 where not possible so much database
4. in storeprocedure we can write try catch statemenet in
2005 not in 2000
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is the difference between system.stringbuilder and system.string
Why is global asax is used?
Explain asp.net web forms.
What are query strings used for?
Can I have a unique key as foreign key?
Which namespace is used by ado.net?
What does asp stand for in asp.net?
Differentiate between namespace and assembly.
Explain the different parts that constitute ASP.NET application?
What is content place holder?
What is a session government?
What are the different types of validation controls provided in ASP.NET?
Where do the cookie state and session state information be stored?
Explain about asp.net 2.0 themes?
How can we create Tree control in asp.net?