Answer Posted / raghu
use xml datatype in sql server 2005
If still working in sql server 2000 use ntext datatype
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Define tempdb database?
What is the use of partition by in sql server?
What is the difference between count () and rowcount ()?
What is the use of group by clause?
What are the new features of sql server 2008 r2 reporting service?
Explain different types of self contained sub query?
Define model database?
User wants only to display only pdf as export option in report manager. How to achieve this?
What are the advantages of using stored procedures?
Tell me about the approaches which you used to counter the DI problems.
What is sql injection? How to protect against sql injection attack?
What are data resources?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Do you know the policy based administration feature of sql server 2008?
how can a database be repaired? : Sql server administration