Answer / muhammad usman(lahore)

An extended stored procedure is simply a procedure that is
implemented in a dynamic link library (DLL) — a library
that is called by an application at runtime. Extended
stored procedures can be used in much the same way as
database stored procedures, except that extended stored
procedures normally perform tasks related to the
interaction of SQL Server with its operating environment

In which database can extended stored procedures be added?

0 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---

What is denormalization and when would you go for it?

9 Answers   NBP,

---

How to create an external table.

1 Answers  

---

Explain about query and reporting.

0 Answers  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

---

What are the 18 schemas?

0 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how

0 Answers   CTR, Infosys, Polaris,

---

Can an extended stored procedure be called from inside a user-defined function?

0 Answers  

---

What is the system function to get the current user's user id?

4 Answers  

---

What are the three basic rules which are to be followed for the relational model of the database?

0 Answers  

---

explain detail about ftp in datastage?

0 Answers   IBM,

---