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
Explain the use of keyword with encryption. Create a store procedure with encryption?
When columns are added to existing tables, what do they initially contain?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Why do we use functions?
How to choose all records from the table?
How do you rename a table in sql server?
What are the advantages of the mirroring?
Name few endpoints exposed by ssrs 2012?
Explain acid?
How to delete duplicate rows?
What are the differences between union, intersect, and minus operators?
What are the differences between stored procedure and the dynamic sql?
What is a file group?
What do you understand by mirroring and mention the advantages of the mirroring?
How many types of triggers in sql server?