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 are early binding and late binding.
What is a web based system?
What is the advantage of using Windows authentication in a Web application?
Describe paging in asp.net?
Explain server-side scripting and client-side scripting.
What is a web api? Which protocol is used in a web api?
How do you design a website with multilingual support in ASP.NET ?
Name the namespace which is used by ado.net?
Explain the difference between value type and reference type?
Explain the asp.net mvc request life cycle? : asp.net mvc
Why is asp.net so popular?
What will happen if the server confugration file and the application confugration file have different values for sassion state ASP.NET?
How can you register a custom server control to a web page?
Which is faster union or union all?
Where the cookie value is stored?