Answer / monal

using linked server or using openrowset command.

Answer / hemendra

using external table

What is row by row processing ?

2 Answers  

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---

Explain the properties of the relational tables?

0 Answers  

---

What is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

What is trigger explain with program?

0 Answers  

---

What is the use of Port no?

1 Answers   Wipro,

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

What is difference between materialized view and view?

0 Answers  

---

How to link up the text file to a Database table?

2 Answers   Allianz,

---

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

0 Answers  

---

Do you know what are acid properties of transaction?

0 Answers  

---