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
What is transact-sql language?
What is isolation levels?
What is PROJECTION Operation?
How to create an inline table-valued function?
Explain system views?
How except clause is differs from not in clause?
How to connect to a sql server using odbc_connect()?
Explain security with sql azure?
What do I need to start working with sql studio? : sql server management studio
How to modify the underlying query of an existing view?
Can we check locks in database? If so, how can we do this lock check?
Explain about temporary stored procedure?
Define clusters?
What is partition, how will you implement it? : sql server analysis services, ssas
what's the difference between delete table and truncate table commands? : Sql server database administration