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 |
IS IT POSSIBLE TO SET TIME FOR COOKIES?HOW IT IS POSSIBLE.
Which property needs to be set for script manager control to extend the time before throwing time out expection if no response is received from the server?
What?s the difference between Codebehind="MyCode.aspx.cs" andSrc="MyCode.aspx.cs"?
How does the regular expression validator work? What are two situations when you might want to use one?
How to sign out from forms authentication?
If we remove web.config or machine.config from the application then, is this application will works?
What does uri mean?
what is structured data format?
How to remove cache object in asp.net?
when the threads are used in dot net.
How to disable validator control by client side JavaScript?
I have an excel file with data, i am importing this excel file data into Sqlserver 2005 database. while importing i am getting wrong data(ie, special characters) in one column(description column), upto some limit the data in that column is coming fine,after that data is coming like below. The "Walter" leather storage bench is one of our most popular styles. The top with the tufting and double stitching finish a very impressive piece. The size is perfect in front of beds and the storage adds another functional bonus. Open it up and sneak al���Ƴ�Â��ƴ�Ã��ƶ�Å�� al���Ƴ�Â��ƴ�Ã��ƶ�Å�� Is there anywhy to resolve this? (I am using recordset in coding for developing import process.) please help me soon.
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)