Answer / raghu

use xml datatype in sql server 2005
If still working in sql server 2000 use ntext datatype

Answer / girish

Use ntext datatype in sql server 2005

Answer / prajakta salvi

we can store file name with full path in the database. And
when retrieve we can cal the same. It is then possible to
store any file with any extension.

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

Explain view in sql server?

0 Answers  

---

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers  

---

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?

0 Answers  

---

What is a self join in sql server?

0 Answers  

---

how many bits ip address consist of? : Sql server database administration

0 Answers  

---

How to create a view with data from multiple tables?

0 Answers  

---

What are the different types of backups that exist?

0 Answers   ADITI,

---

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

What are indexers?

0 Answers  

---