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

What is transact-sql language?

1020


What is isolation levels?

973


What is PROJECTION Operation?

969


How to create an inline table-valued function?

921


Explain system views?

1030


How except clause is differs from not in clause?

903


How to connect to a sql server using odbc_connect()?

1102


Explain security with sql azure?

186


What do I need to start working with sql studio? : sql server management studio

1059


How to modify the underlying query of an existing view?

941


Can we check locks in database? If so, how can we do this lock check?

902


Explain about temporary stored procedure?

946


Define clusters?

1008


What is partition, how will you implement it? : sql server analysis services, ssas

1005


what's the difference between delete table and truncate table commands? : Sql server database administration

941