What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
- 3 Answers
- 12733 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / swapna
An extended stored procedure is a function within a DLL
(written in a programming language like C, C++ using Open
Data Services (ODS) API) that can be called from T-SQL,
just the way we call normal stored procedures using the
EXEC statement.
Yes, you can instantiate a COM (written in languages like
VB, VC++) object from T-SQL by using sp_OACreate stored
procedure. For an example of creating a COM object in VB
and calling it from T-SQL
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is clustered index
Explain “row_number()” in sql server with an example?
How to convert character strings into numeric values?
Can you index views?
How to connect php with different port numbers?
What is normalization and what are the advantages of it?
Where can you add custom error messages to sql server?
How to remove duplicate rows from table except one?
What is a view in sql?
How do I find the sql server version?
What is sql server query analyzer?
List the ways in which dynamic sql can be executed?
What is standby servers? Explain types of standby servers.
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What are wait types?
