What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
- 1 Answers
- 4150 Views
- 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are transactions in sql?
Can I run multiple instances of sql server 2000 at the same time on one computer?
When columns are added to existing tables, what do they initially contain?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What is the importance of a recovery model?
What is the benefit of normalization?
What is the purpose of the tempdb database?
What are the properties of sub-query?
Write SQL queries on Self Join and Inner Join.
How to use column default values in insert statements in ms sql server?
What is it unwise to create wide clustered index keys?
Does transparent data encryption provide encryption when transmitting data across the network?
What is the difference between an index and a unique index?
How to generate create view script on an existing view?
