What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
- 3 Answers
- 11849 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
Do you think BCNF is better than 2NF & 3NF? Why?
Do you know what is xpath?
Equi join and non equi join is possible with sql server?
When would you use it?
Mention the 3 ways to get a count of the number of records in a table.
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is the ‘fillfactor’?
Explain the collation?
Explain view in sql server?
What can be used instead of trigger?
What is statement level trigger?
What is the difference between delete and truncate statements?
What is usually the first word in a sql query?
Explain hostprotectionattribute in sql server 2005?
Do you have any idea about the tcl commands?
