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
- 8247 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
How can windows applications connect to sql servers via odbc?
What is difference between count (*) and count column?
What is database replication?
What are the advantages of using stored procedures?
Does index speed up select statements?
What are exact numeric data types in ms sql server?
What is meant by indexing files?
What is the purpose of update statistics and scope_identity() function?
Explain how would you store your query in an SSRS report or a Database server?
What are the five major components of a dbms?
What is the importance of concurrency control?
What is the Difference Between Primary and Foreign Key?
What is outer join in sql server joins?
What is cursors? And what are the different types of cursor?
what is normalization? Explain different levels of normalization? : Sql server database administration
