Interested to Buy Any Domain ? << Click Here >> for more details...
Diffrences between sql server 2000 vs 2005
- 2 Answers
- 4924 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / sakthi
for error handling in 2005 we use try catch, new functions
like pivot and unpivot, datatype nvarchar(max), varchar
(max), char(max) to handle xml in 2005 we have special
datatype caller XML.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Describe how to use the linked server?
What are four major operators that can be used to combine conditions on a where clause?
What is subquery? Explain the properties of a subquery?
How to return the second 5 rows in ms sql server?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How to create a user to access a database in ms sql server using "create user" statements?
Is sql server difficult to learn?
What is difference between stored procedure and user defined function?
What is partition in sql server?
do views contain data ?
Can the query output be sorted by multiple columns in ms sql server?
What is the difference between a function and a trigger?
What are some examples of schemas?
Do you know what are different types of replication in sql server?
Explain indexed views?
