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
- 9336 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
What is precedence constraint?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Define inner join? Explain with an example?
What is microsoft sql server?
How to connect sql server management studio express to sql server 2005 express?
How to delete duplicate rows from table except one?
Do you know what are the ways available in sql server to execute sql statements?
What is partition in sql server?
When I delete any data from a table, does the sql server reduce the size of that table?
How to disable stored procedure sql server?
What are commit and rollback in sql?
Can I disable or restrict ssrs export formats (rendering formats)?
what is database replicaion? : Sql server database administration
What happens if strings are casted into wrong code pages in ms sql server?
What are the different types of join?
