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               Login  |  Sign Up                         To Refer this Site to Your Friends   Click Here

Categories >> Software >> Databases >> SQL Server        Suggest New Category      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 |            Copyright © 2012  ALLInterview.com.  All Rights Reserved. ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com