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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain table valued parameters in sql server? Why tvp used?

1014


What do you mean by data manipulation language?

1007


What is the sql server agent?

1080


What are the different sql server versions?

971


After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

946


How will you hide an attribute? : sql server analysis services, ssas

952


How many types of schemas are there?

1036


Explain alternate key, candidate key and composite key in sql server?

905


What are the steps you should follow to start sql server in single-user mode?

896


Does group by or order by come first?

952


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8147


How to connect of datebase with sql express.?

1094


What is the difference between delete and truncate statements?

1065


How to copy data from one table to another table?

993


what does the automatic recovery do? : Sql server administration

1014