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 the use of commit?
What do you mean by data integrity?
Can primary key be a foreign key?
What is the purpose of sql profiler in sql server? : sql server database administration
Is sql server implemented as a service or an application? : Sql server database administration
What different steps will a sql server developer take to secure sql server?
Can you explain what is the use of custom fields in report?
What is delete query?
Explain having clause and where clause?
What are examples of triggers?
What is cursors? And what are the different types of cursor?
How can you find out which stored procedures are recompiling?
Can an automatic recovery be initiated by a user?
What is the difference between row_number and dense_rank?
What is single-user mode?