what is the difference between sql 2000 and 2005?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / interviewman
SQL Server has SSIS , SSRS and SSAS
<a href="www.questpond.com">.NET Interview questions</a>
| Is This Answer Correct ? | 1 Yes | 2 No |
what do you mean software devlopment ?
What is difference between asp.net and asp?
suppose we have two object;obj1 and obj2 can we assign obj2 to one1; and if yes; then after assigning suppose we delete obj2 then obj1 will retain obj2 value or not.
Difference between asp and asp.net?
What kind of data we can store in viewstate?
How do you remove duplicates without using remove duplicate stage?
What are different types of api?
Which browsers support the xmlhttprequest object?
How do you turn off cookies for one page in your site?
What is mta?
Types of object in asp ?
What is full trust in asp.net?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)