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
- 12660 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 the types of user defined functions in sql server?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is the recovery model?
How to list all triggers in the database with sys.triggers in ms sql server?
What are the types of lock supported by ?
Explain “not null constraint” in sql server?
What will happen if a column containing char type data is changed to the nchar data type?
What is the difference between count () and rowcount ()?
What is TDS(Tabular Data Stream) Gateway?
What is compression - row-level and page-level compression?
What is lock escalation? : sql server database administration
What are the new scripting capabilities of ssms? : sql server management studio
What encryption security is available in sql azure?
Does table partitioning improve performance?
What are the database roles? : sql server security
