Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference Between Sql-server 2000 & 2005
- 3 Answers
- 10608 Views
- Value Labs, Wipro, I also Faced
- E-Mail Answers
Answer Posted / savitha
2005sqlser support try catch which is not possible in 2000
In SQL Server 2000 , a row cannot exceed 8000 bytes in
size ... To solve this problem, Microsoft introduced the
VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) data types
in SQL Server 2005. These data types can hold the same
amount of data BLOBs can hold (2 GB)
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
After removing a table from database, what other related objects have to be dropped explicitly?
What are the mathematical functions supported by sql server 2005?
How to specify the collation for a character data type in ms sql server?
What are different types of collation sensitivity?
Can we write a distributed query and get some data which is located on other server and oracle database?
What is difference between materialized view and view?
What is stored in the mssqlsystemresource database? : sql server database administration
What is the use of custom fields in report?
What is ms sql server index?
What does the not null constraint do?
How to compare the top two records using sql?
How to view existing indexes on an given table using sys.indexes?
Is it possible in sql table to have more than one foreign key?
What does null mean?
What is the purpose of a table?
