Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain indexed views?

1025


What are user-defined functions (udfs) in sql server?

1040


What are the characteristics of modern DBMS?

1137


How do you know if sql server is running on your local system?

1090


How to backup encryption key ?

191


What is named query? : sql server analysis services, ssas

996


What are ddl triggers and types of ddl trigger?

1091


Explain forward - only cursors?

1121


Name three of the features managed by the surface area configuration tool? : sql server security

1028


What are the limitations/drawbacks or ssrs 2008 r2?

152


Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1093


Do you know what is normalization of database? What are its benefits?

1197


What are system databases into sql server (2005/2008)?

1040


What is wide table?

1012


How to fine-tune reports?

279