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
Explain table valued parameters in sql server? Why tvp used?
What do you mean by data manipulation language?
What is the sql server agent?
What are the different sql server versions?
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
How will you hide an attribute? : sql server analysis services, ssas
How many types of schemas are there?
Explain alternate key, candidate key and composite key in sql server?
What are the steps you should follow to start sql server in single-user mode?
Does group by or order by come first?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How to connect of datebase with sql express.?
What is the difference between delete and truncate statements?
How to copy data from one table to another table?
what does the automatic recovery do? : Sql server administration