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
Explain what are the advantages of asp.net mvc framework? : asp.net mvc
How to retrieve user name in case of Window Authentication?
What is the default authentication mode for asp.net?
What kind of programming language is ASP.NET?
Explain the various authentication mechanisms in asp.net.
What is data grid view in asp.net?
Is asp.net outdated?
How many web config files can be created for an application?
How can you identify that the page is post back?
What is the difference between localization and globalization?
Which protocol is used to call a web service?
To bind columns manually which tags do you need to add within the asp:datagrid ?
What is asp.net and its advantages?
How can you make sure that web api returns json data only?
What are sql notifications and sql invalidations?