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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Which data type can be used only on OUTPUT parameters of the
stored proceduer?

Question Posted / mohanakrishnan a.c

Answers were Sorted based on User's Feedback



Which data type can be used only on OUTPUT parameters of the stored proceduer?..

Answer / madhusudan singh kushwah

Stored procedure return data In 4 ways. which are as follow:

1)output Prameter:-which can return either data(such As
integer or char value) or a cursor variable(cursors are
result sets that can be retreived 1 row at a time).

2)return Codes:-Which are always an Integer Value.

3)A result set for each statement contain in Stored
procedure or any other Stored procedures called by the
Stored Procedure.

4)A global cursor that can refrenced outside the procedure.

Is This Answer Correct ?    4 Yes 1 No

Which data type can be used only on OUTPUT parameters of the stored proceduer?..

Answer / jothi

Cursor

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is partition in sql server?

0 Answers  

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

Define ACID properties in a Database?

0 Answers   iNautix,

What is difference between rownum and rowid?

0 Answers  

What is MSDE?

2 Answers  

what is a check constraint?

0 Answers  

Explain intellisense for query editing

0 Answers  

What is the difference between dataadapter and datareader?

0 Answers  

How to stop a loop early with break statements in ms sql server?

0 Answers  

What is hot add cpu in sql server 2008?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories