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

How do you test your database? : sql server database administration

1021


Name three of the features managed by the surface area configuration tool? : sql server security

991


How do I create a trace in sql server?

1042


Tell me what is de-normalization and what are some of the examples of it?

1046


what is package and it uses and how can u call a package

2014


What is a mixed extent?

1025


How to configure and test odbc dsn settings?

1160


Do you know what are the reporting services components?

975


What do you mean by subquery?

1087


Explain the steps to use transact-sql cursor?

1063


Mention the different types of triggers?

1117


Why can there be only one clustered index and not more than one?

1005


How to Check if table exists in sql server?

1136


What is awe?

1012


What are ddl (data definition language) statements for tables in ms sql server?

1104