Answer Posted / ashis
Sql server 2005 have some new data types like varchar
(max),xml. Sql server 2005 have SSIS instead of dts in sql
server 2000. SSRS with adhoc reporting. Some sys command
are changed like sys.objects, sys.columns.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is candidate key with example?
How to fine-tune reports?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What are four major operators that can be used to combine conditions on a where clause?
What do you need to connect php to sql server?
Difference between Sql server reporting services and Crystal reports?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is an inner join?
What happens if null values are involved in boolean operations?
What is self contained scalar sub query?
What is sql server schema compare? How we can compare two database schemas?
Write a program using SQL queries to find a unique entry in a table.
How to call stored procedure using http soap?
What are xml indexes?
What happens if null values are involved in bitwise operations?