Interested to Buy Any Domain ? << Click Here >> for more details...
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 an indice?
Is resultset an interface?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Different types of keys in SQL?
How many primary keys are possible in a table?
How to query multiple tables jointly?
Explain different types of locks in sql server.
What is difference between equi join and natural join?
What is the difference between mysql and sql server?
Explain the concept of recursive stored procedure.
Explain forward - only cursors?
How to find the list of fixed hard drive and free space on server?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is data block and how to define data block size?
