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 ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the dmvs? : sql server database administration
What is pessimistic concurrency?
What are the types of normalization?
Using the customer, and order table in northwind database, please write a query to produce xml?
What do you understand by recursive stored procedures?
What is difference between temp table and cte?
What are different types of subquery?
what is package and it uses and how can u call a package
How to drop an existing schema in ms sql server?
What is stored in the mssqlsystemresource database? : sql server database administration
How many categories of functions based their return modes?
What is tablesample?
How to divide query output into multiple groups with the group by clause in ms sql server?
What are the new scripting capabilities of ssms? : sql server management studio
List out the differences between the clustered index and non-clustered index in sql server?