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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   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 
how many types of store procedre in sqlserver 2000?
 Question Submitted By :: Sharifuddin
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how many types of store procedre in sqlserver 2000?
Answer
# 1		 
Their Are Two Type Of SP
1)System SP
2)dbo (DataBase Owner) mean User Defined SP
 
Is This Answer Correct ?    2 Yes 1 No
Dinesh Sharma
 
  Re: how many types of store procedre in sqlserver 2000?
Answer
# 2		 
Types of StoredProcedures

1.Userdefined StoredProcedures
2.SystemDefined storedprocedure
3.Temporary
4.Remote
5.Extended
 
Is This Answer Correct ?    0 Yes 1 No
Prashanthi G
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?  2
what is trigger NIIT1
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?  2
Difference between Triggers and Stored Procedure Protech9
Explain Different types of Projects?  1
What is indexed views? plz explain with example?  1
to explain sql server 2000 architecture & authentication  1
Is it possible to create tables in stored procedures using a variable for the table name?  2
how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables? Lason2
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables? TCS3
What is cursor ? And what is difference between Trigger ? HCL1
What is lock escalation?  1
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005  3
What is Report Server,Report Manager and Report Builder in SSRS 2005?  1
Can you explain the role of each service?  1
What is the difference between local table and global table Polaris1
Explain Active/Active and Active/Passive cluster configurations?  1
difference between sql server2000 and sql server2005 KPMG1
which one will take 1st priority in case of insert statement and select statement???  1
explain different types of jions with examples briefly? Zensar2
 
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