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
Can two tables have the same primary key?
How can I add Reporting Services reports to my application?
What is the command to change the recovery model?
How to resolve the orphan use problem? : sql server security
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What are two difference between sql azure and azure tables?
What is the difference between index seek vs. Index scan?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is filtered index?
What is subquery in sql?
What are policy management terms?
how to determine the service pack currently installed on sql server? : Sql server database administration
How many null values we can have in a unique key field in sql server?
Explain comment on transactions?
What are the new features are introduced in sql server 2012 reporting services?