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 
How do we return a record set from a Stored Procedure in SQl
server 2000?
 Question Submitted By :: Honeysukumar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do we return a record set from a Stored Procedure in SQl server 2000?
Answer
# 1		 
Select  select_list from my_tabel
 
Is This Answer Correct ?    0 Yes 0 No
Sd
 
  Re: How do we return a record set from a Stored Procedure in SQl server 2000?
Answer
# 2		 
SQL Server stored procedures can return multiple record 
sets. The following is an example:

CREATE PROCEDURE procCustomerGet
@CustomerID VarChar(5)
AS
     SELECT * FROM Customers
	   WHERE CustomerID = 
           @CustomerID
     SELECT * FROM Orders
           WHERE CustomerID =
           @CustomerID
 
Is This Answer Correct ?    2 Yes 0 No
Madhu
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is an index? Yardi-Software7
What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table HP15
What are cursors?  8
Can some one please help with a query which will take only max value of a column in a join.  2
What is the use of placing primary key and foreign key constrains on columns. Value-Labs2
Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!  1
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)  1
What are Magic Table? Evalueserve15
select top 5 * from emp order by newid() my question is , how this query get executed?  4
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder IBM1
how to get 25th row in any table in sqlserver can u tell me syntax  4
How would you Update the rows which are divisible by 10, given a set of numbers in column?  1
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?  3
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer. Satyam4
Can I remove the default constraint columns in SQL SERVER? Value-Labs3
what is mean by crystal repoart? ahere we will mainly use that?  1
What are the different ways of moving data/databases between servers and databases in SQL Server? HCL2
what is the output for this query select * from employee where 1=1;  4
What does the INSTEAD OF trigger do?  3
can foreign key take role of primary key? TCS4
 
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