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
- 12536 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 store procedure? When do you use?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How to automatically create a log when an exception is being received into SQL Server?
Explain optimistic and pessimistic concurrency?
What program is used to store the data source file?
What is the return type of executeupdate ()?
What is the purpose of the tempdb database?
How to enable/disable indexes?
Explain the purpose of indexes?
What are the fixed server level roles? : sql server security
What are the benefits of normalization?
What is surrogate key? : sql server analysis services, ssas
what are constraints? : Sql server database administration
What is dbcc? Give few examples.
What is nolock hint in sql server 2008
