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 cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
How to execute stored procedure in select statement sql server?
explain how to create a new schema in a database? : Sql server database administration
Do you know exporting and importing utility?
What is the use of keyword with encryption.
What is database replication?
What is inner join in sql server joins?
What is the difference between locking and multi-versioning?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What do you know about system database? : SQL Server Architecture
How extra digits are handled with numeric data type literals?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How do you migrate data from mssql server to azure?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How do I make a resultset scrollable?