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

1.what is the purpose of using alias name in sql server?
with certain example?

2.what is cursor?will u plz explain me in detail with
certain example?

Question Posted / anithababu1

Answers were Sorted based on User's Feedback



1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?..

Answer / sujit sarkar

The main purpose of alias is we can define one object (like
table,column..) from another object which is used in sql
statement.
Suppose you need average salary and salary

then you can write

Select salary/12 as 'average salary' from salary

Is This Answer Correct ?    13 Yes 1 No

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?..

Answer / lekhrajdeshmukh

Cursor:- Cursor is special data type of mssql server.
Cursor is mainly used for extracting the row by row data
from tables.
cursor is the only data type that can not be used in table.
Cursor is mainly used in stored procedure and when we have
to use cursor in SP need to perform the following steps:-
1)declaring a cursor.
2)Open a Cursor
3) fetching the cursor
4)close the cursor.

Is This Answer Correct ?    9 Yes 0 No

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?..

Answer / lekhrajdeshmukh

Cursor:- Cursor is special data type of mssql server.
Cursor is mainly used for extracting the row by row data
from tables.
cursor is the only data type that can not be used in table.
Cursor is mainly used in stored procedure and when we have
to use cursor in SP need to perform the following steps:-
1)declaring a cursor.
2)Open a Cursor
4)close the cursor.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is database normalization?

7 Answers   Deloitte, Digicel, JPMorgan Chase, Verifone,

What is RAID? What are the different types of RAID configurations?

0 Answers   Flextronics,

Does index speed up select statements?

0 Answers  

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

Name few of the dcl commands in sql?

0 Answers  

What do you mean by data manipulation language?

0 Answers  

How to create Clustered Primary Key to table?

2 Answers  

Detail about query optimizer?

0 Answers  

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,

What is data source document?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories