Answer / Kiran Kumari

"Yes, NULL is a special value in SQL Server that represents an absence of data in a column."

How to find which stored procedure is currently running in sql server?

1 Answers  

---

What is the use of RDBMS?

1 Answers   Wipro,

---

Explain what is meant by replication of database?

1 Answers   Cap Gemini,

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1 Answers  

---

How to create a store procedure with encryption?

1 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

What is an indexing technique?

1 Answers  

---

Who is the owner of a schema in ms sql server?

1 Answers  

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

1 Answers  

---

What is the difference between a fill factor of 100 and 0?

1 Answers  

---

What is the definition for sql server 2000?

1 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---