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
What are the different types of lock modes in sql server 2000?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is the difference between web edition and business edition?
What is the difference between count () and rowcount ()?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What stored by the tempdb ? : sql server database administration
What is the most common type of join?
What is the difference between nvl and nvl2?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is a periodical index?
What are temporal tables in sql server 2016?
What is difference between equi join and inner join?
What are unicode character string data types in ms sql server?
Write a SQL queries on Self Join and Inner Join.