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       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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 
Can you give an example of Stored Procedure?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Can you give an example of Stored Procedure?
Answer
# 1		 
sp_helpdb , sp_who2, sp_renamedb are a set of system defined
stored procedures. We can also have user defined stored
procedures which can be called in similar way.
 
Is This Answer Correct ?    1 Yes 0 No
Guest
 
  Re: Can you give an example of Stored Procedure?
Answer
# 2		 
user defines sp...
say i want to select some values based on parameter 

create sp dbo.spname
'declare var

@parametername  int
as 
select * from table_name
where  file_name=@parametername
 
Is This Answer Correct ?    1 Yes 0 No
Ghous
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Can you give an example of Stored Procedure?  2
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no. iFlex2
Explain Trigger with an example?  1
What command do we use to rename a db?  3
what is difference between having and where clause ?  2
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?  6
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?  2
What is the difference between temp table and table variable? Microsoft4
how can i store resumes in database? HCL2
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))????? SAP-Labs2
can you any body tell me the difference between candidate key and primary key  4
how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100 HCL6
Explain DBMS, RDBMS?  4
What are mdf,ndf,ldf files and how to see the data in those files? Accenture5
What are the different ways of moving data/databases between servers and databases in SQL Server?  1
Different Types of Functions ? Satyam2
Is it possible to delete duplicate rows in a table without using a temporary table ?  6
How reterive duplicate value in SQL?  5
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE IBM1
Difference between Triggers and Stored Procedure Protech9
 
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