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       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ASP.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
Create the Output by mearging 2 tables and taking common
column sid from both you should not use database create
table and data in it Randomly 

table 1
sid sname saddress
1    sa    ampt  
2    na    hyd
3    ha    hyd

table 2
sid dno dname
1   12  stats
2   23  phy
3   12  stats

OutPUt
sid sname saddress did dname
1    sa    ampt     12  stats
2    na    hyd      23  phy
3    ha    hyd      12  stats
 Question Submitted By :: Santosh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Create the Output by mearging 2 tables and taking common column sid from both you should not use database create table and data in it Randomly table 1 sid sname saddress 1 sa ampt 2 na hyd 3 ha hyd table 2 sid dno dname 1 12 stats 2 23 phy 3 12 stats OutPUt sid sname saddress did dname 1 sa ampt 12 stats 2 na hyd 23 phy 3 ha hyd 12 stats
Answer
# 1
select t1.sid ,t1.sname ,t1.saddress,t2.dno,t2.dname
 from table1 t1
inner join  table2 t2 on t1.sid=t2.sid


Regards,
Praveen Singh
praveen.kumar4u1093@gmail.com
 
Is This Answer Correct ?    0 Yes 0 No
Praveen Singh
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
I create small website, i want accept all the browser this website? what will do?  1
About dataset and data mining ? Cognizent1
What are the major differences between asp.net1.1 and asp.net 2.0? CTS7
What does the "EnableViewState" property do? Why would I want it on or off?  4
Difference between Dataset and DataReader ? Accenture4
What are the differences between Dataset and DataReader? Accenture3
Types of objects in ASP? Microsoft5
What is the other method, other than GET and POST, in ASP.NET?  3
What layout mode is the default when a new Web Form is created? a) GridBagLayout b) GridLayout c) FlowLayout d) FormLayout Syntax-Softtech2
How will u decide when to use caching and when to use viewstate?  3
What are the different methods that are used during the page load?  1
What is strong-typing versus weak-typing? Which is preferred? Why?  1
What is the use of web.config? Difference between machine.config and Web.config?  3
Explain which is best suited place in the Application Start and Session_Start subroutines with an example?  3
what is the requirement that .Net web services can access the java application? iSoft6
Write a code for "RequiredFieldValidator" in java script Wipro3
How do you use a custom validator? When might you want to use one?  1
what is CLR? PrimeLine3
How do you manage session in ASP and ASP.NET? Microsoft1
Descrie about response.buffer and repsonse.flush ? Cognizent1
 
For more ASP.NET 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