What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
Answer / 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 |
Explain various data region available in ssrs with their use?
What is truncate table?
Please tell me some knowledge about Clustering and how to add clustering?
What are the types of processing and explain each? : sql server analysis services, ssas
Do you know what is xpath?
Define outer join in sql server joins?
How many triggers you can have on a table?
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE
application server is slow what may be the problem
How can I create a new template for import ? : sql server management studio
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?