ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
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?
 Question Submitted By :: AnithaBabu1
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
# 1		 
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 ?    2 Yes 0 No
Sujit Sarkar
 
  Re: 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
# 2		 
Cursor:- Cursor is special data type of mssql server.
Cursor is mainly used for extracting the row by row data
from tables.
cursor is the only data type that can not be used in table.
Cursor is mainly used in stored procedure and when we have
to use cursor in SP need to perform the following steps:-
1)declaring a cursor.
2)Open a Cursor
3) fetching the cursor
4)close the cursor.
 
Is This Answer Correct ?    2 Yes 0 No
Lekhrajdeshmukh
 
 
 
  Re: 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
# 3		 
Cursor:- Cursor is special data type of mssql server.
Cursor is mainly used for extracting the row by row data
from tables.
cursor is the only data type that can not be used in table.
Cursor is mainly used in stored procedure and when we have
to use cursor in SP need to perform the following steps:-
1)declaring a cursor.
2)Open a Cursor
4)close the cursor.
 
Is This Answer Correct ?    0 Yes 0 No
Lekhrajdeshmukh
[Cellebrum Pvt Ltd]
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the difference between a stored procedure and a user defined function in sql server? Millennium2
How to Get the last identity value used  4
Which command using Query Analyzer will give you the version of SQL server and operating system?  3
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)? Marlabs8
Please tell me some knowledge about Clustering and how to add clustering?  1
What are the advantages of using sql server over ms access or why should one use sql instead of ms access Impetus1
What is the difference between views and stored procedures? Can we have input parameters for views?  3
What is the difference between UNION and UNIONALL? CTS2
What does it mean to have quoted_identifier on? What are the implications of having it off?  2
What is a Trace frag?Where can we use this?  1
What is the difference between truncate and delete statement? CTS4
Can you give an example of Stored Procedure?  2
What are SQL Jobs, please mention the use of it and how to create them. 247Customer1
what operator performs pattern matching?  1
What are primary keys and foreign keys?  3
What is mean by "fill factor" ? and what is mean by "Index "in sql? Logica-CMG1
is there more the two primary key in a single table? Systematix22
What is transaction ? Give me one example. Melstar7
What is BCP? When do we use it?  1
What do you mean by COLLATION?  4
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com