Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference Between Sql-server 2000 & 2005
- 3 Answers
- 10501 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
What are the features of Embedded SQL
How to use values from other tables in update statements in ms sql server?
How to drop an existing schema in ms sql server?
Explain the flow of creating a cube? : sql server analysis services, ssas
What is a document index?
What is a rownum?
What is the difference between sdf and mdf?
What is data block and how to define data block size?
explain different levels of normalization? : Sql server database administration
Define right outer join?
what is a deadlock? : Sql server database administration
How to test a dml trigger in ms sql server?
Explain a differential backup?
Write SQL queries on Self Join and Inner Join.
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
