ALLInterview.com :: Home Page            
 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   To Refer this Site to Your Friends   Click Here
Google
   
 
 Categories >> Software >> Databases >> SQL Server       
Suggest New Category 
 


 

View Page with Answers
  Question  Asked @ Answers Views     select
 
I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access Krishan  1  21
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product  1  179
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible HCL   0  88
What Is The Difference Between Primary Key & Super Key  2  269
write a query to remove duplicate records without using primary key column? ABCO  2  438
hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table Indecomm  2  257
Simple example for difference between select and cursor in sql  0  218
Psudo colums hp  1  238
One table how may column and Primary key  3  553
syntax and example for bitmap index in sql???  1  392
can any one say how to update the following senario I have a table <srabank> in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <accountno> <31518746291> the balance is <4000> for the <accno> <31518746292> the balance is <14000> after transferring the balance the details will look as follows <accno><31518746291> <bal> <2000> <accno><31518746292> <bal> <16000> the above mentioned two statment will come under the final result.  1  270
what is victor class  0  256
can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -  2  360
what is diffrent between store procedure and trigger  2  646
what's the difference between SQL & MY-SQl...? And what we learn from these ....? Broadridge  0  261
E-Mail New Answers        Answer Selected Questions        Post New SQL Server Question
 [1]    2  ... 6   ... 11   ... 16   ... 21   ... 26   ... 31   ... 36   ... 41   ... 46   ... 51   ... 56   ... 61   ... 66   ... 71    Next
 
 
    Oracle Interview Questions     SQL Server Interview Questions     MS Access Interview Questions
    MySQL Interview Questions     Postgre Interview Questions     Sybase Interview Questions
    DB Architecture Interview Questions     DB Administration Interview Questions     DB Development Interview Questions
    SQL PLSQL Interview Questions     Databases AllOther Interview Questions
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
What is data modeling and Reterminal integrity? 114  
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do 75  
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp? 428 TCS
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram 131  
what are the Prerequisites for Replication? 967 IBM
When we can say that is in BCNF? 354 BitWise
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter. 121  
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions . 175 HCL
what are the critical issues you have resloved in your company 117 Wipro
what are the limitations of parameters in a storedprocedure 227  
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance 124  
Scalability, Availability, Integration with internet, etc.)? 352  
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

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