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
- 12397 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 are audit control procedures?
State a few properties of relational databases?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Would you store your query in a ssrs report or a database server? State the reason why?
What is a heap?
What is dbcc updateusage?
How do I uninstall sql server 2014?
How to list all field names in the result set using mssql_field_name()?
What is inline table-value user-defined function?
What is the difference between stored procedure and user defined functions?
Can you explain what is the use of custom fields in report?
Tell me about normalization in DBMS.
How do I edit a stored procedure in sql server?
What are approximate numeric data types in ms sql server?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
