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
How do you test your database? : sql server database administration
Name three of the features managed by the surface area configuration tool? : sql server security
How do I create a trace in sql server?
Tell me what is de-normalization and what are some of the examples of it?
what is package and it uses and how can u call a package
What is a mixed extent?
How to configure and test odbc dsn settings?
Do you know what are the reporting services components?
What do you mean by subquery?
Explain the steps to use transact-sql cursor?
Mention the different types of triggers?
Why can there be only one clustered index and not more than one?
How to Check if table exists in sql server?
What is awe?
What are ddl (data definition language) statements for tables in ms sql server?