Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9068 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
Explain about system stored procedure?
What is logon trigger?
What is the difference in accessing db between sql server vs sql azure?
what is an extended stored procedure? : Sql server database administration
Do you know what is sql injection?
what are the disadvantages of cursors? : Sql server database administration
Which sql server table is used to hold the stored procedure script?
Explain about Joins?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What are different types of raid configurations? : SQL Server Architecture
Explain the collation?
What is the difference between Stored Procedures and triggers?
What are the differences between union, intersect, and minus operators?
What is the recovery model? List the types of recovery model available in sql server?
How many levels of sp nesting is possible?
