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

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  

What is transaction server explicit transaction?

0 Answers  

What is stretch database in sql server?

0 Answers  

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

What is query optimizer in sql server?

0 Answers  

What are different types of constraints?

0 Answers  

How do you trace the traffic hitting a sql server?

0 Answers  

How to use union to merge outputs from two queries together in ms sql server?

0 Answers  

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

What are the types of database schema? : sql server analysis services, ssas

0 Answers  

For more SQL Server Interview Questions Click Here
Categories