Interested to Buy Any Domain ? << Click Here >> for more details...
What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
- 3 Answers
- 12507 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
Explain ms sql server reporting services vs crystal reports?
What are the hotfixes and patches in sql server?
What is the difference between TRUNCATE and DROP?
How do you delete a trigger?
What are different types of constraints?
How to get the definition of a stored procedure back?
What is meant by indexing files?
What happens if you delete a table that is used by a view?
Explain different backup plans?
What is the maximum size of a row in sql server?
How to create new tables with "create table" statements in ms sql server?
What is a cache in ssrs?
Explain in brief about Microsoft SQL server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
Which is the latest version of sql server and when it is released?
