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?
- 3 Answers
- 7988 Views
- I also Faced
- E-Mail Answers
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
What is difference between joins and subqueries?
How to retrieve error messages using mssql_get_last_message()?
How to create a trigger for insert only?
Which tcp/ip port does sql server run on? How can it be changed?
Can we return Data from 4(more than 1) tables in stored procedure?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Define indexes?
What is the Difference Between Primary and Foreign Key?
How to concatenate two character strings together?
What encryption security is available in sql azure?
How to create a Master database in SQL server ?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What is difference between delete & truncate commands?
Tell me what is the difference between locking and multi-versioning?
If user is owning any SQL Objects, can we drop that user
