ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
What is an extended stored procedure? Can you instantiate a 
COM object by using T-SQL?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
Answer
# 1		 
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
Swapna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Which is best Subquery (or) joins in sql server? explain why  2
What are cursors?  8
how can we use a composite key for two tables and how can we represent it BoA1
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?  2
What about UPDATESTATISTICS ? Intelligroup2
Can Somebody tell me the difference between Clustered & Non- Clustered Index?? Progressive3
what is cluster and nin-cluster index?  4
how to delete duplicate rows from table CSC9
what is the order of execution of where,having,group by in select stement Tanla-Solutions5
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables? HP1
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they. IBM5
What is the difference between UNION and UNIONALL? CTS2
what is web server? Satyam3
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server. IBM4
What is the difference between constraints and triggers? Wipro6
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3 Google10
how to retrive only second row from table in sql server 2000? CTS7
What is the difference between HAVING clause and the WHERE clause?  4
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)  5
What is a materialized view?  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com