Can somebody provide me SQL questions based on various situation?
I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for practice .
Answer Question
| May 10, 2013 10:15 AM
SQL, SQL Database, SQL queries
I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for practice .
Answer Question
| May 10, 2013 10:15 AM
SQL, SQL Database, SQL queries
Mainframe Careers
I am b.tech CSE fresher and also mainframe trained & certified for the period of 6 months in mainframe system administration& management how should i prepare Myself to hit a job in mainframe stream in good companies ,please suggest
Answer Question
| July 13, 2010 8:17 AM
Careers, IT careers, Mainframe, Mainframe careers
I am b.tech CSE fresher and also mainframe trained & certified for the period of 6 months in mainframe system administration& management how should i prepare Myself to hit a job in mainframe stream in good companies ,please suggest
Answer Question
| July 13, 2010 8:17 AM
Careers, IT careers, Mainframe, Mainframe careers
Avoid duplicate entry in database through VB
I have made a program in VB with Access as back end. In the data base there are three fields which are unique id of a person. I want to display “Already Exist” message box when i enter an already existing id. matching all three fields and not allow duplicate entry.
Answer Question
| January 15, 2010 4:27 PM
Data Deduplication, Delete duplicates, VB6
I have made a program in VB with Access as back end. In the data base there are three fields which are unique id of a person. I want to display “Already Exist” message box when i enter an already existing id. matching all three fields and not allow duplicate entry.
Answer Question
| January 15, 2010 4:27 PM
Data Deduplication, Delete duplicates, VB6
Select/Insert Statements causing out of memory error run under VB Script
I’m using VB Script on a Windows 2003 Server against an Oracle 10g database to both query against a table and insert new rows of data against that same table but as it runs it starts eating up RAM and when it gets to about 1.5gb it causes the out of memory error. As far [...]
Answer Question
| January 27, 2011 8:43 AM
INSERT statement, Oracle 10g, Oracle 10g Database, SELECT statement, Windows Server 2003, Windows Server 2003 32-bit
I’m using VB Script on a Windows 2003 Server against an Oracle 10g database to both query against a table and insert new rows of data against that same table but as it runs it starts eating up RAM and when it gets to about 1.5gb it causes the out of memory error. As far [...]
Answer Question
| January 27, 2011 8:43 AM
INSERT statement, Oracle 10g, Oracle 10g Database, SELECT statement, Windows Server 2003, Windows Server 2003 32-bit
about ccna
i have completed mcse(not certified) i want to do ccna certified also but i dont about it help me pls
Answer Question
| July 12, 2010 7:11 AM
Careers, CCNA, IT careers, Networking careers, Networking certifications
i have completed mcse(not certified) i want to do ccna certified also but i dont about it help me pls
Answer Question
| July 12, 2010 7:11 AM
Careers, CCNA, IT careers, Networking careers, Networking certifications
job opportunity
my acadamics are 86%in 10th,68%in 12th,75%in B.Eup to 6th semester,i have done plc,scada,n+,c,c++ as extra curricular course,also i have taken two year drop in my acadamic calender,so where should i look for job after completing my B.E and what other courses should i do for a secure future,pls guide me i m abit concern
Answer Question
| July 12, 2010 8:35 AM
Careers, IT careers
my acadamics are 86%in 10th,68%in 12th,75%in B.Eup to 6th semester,i have done plc,scada,n+,c,c++ as extra curricular course,also i have taken two year drop in my acadamic calender,so where should i look for job after completing my B.E and what other courses should i do for a secure future,pls guide me i m abit concern
Answer Question
| July 12, 2010 8:35 AM
Careers, IT careers
Cannot INSERT data into table with identity column
In my program I have an EmployeeRegistry table which holds data of each employee’s work attendance. Every attendance record is uniquely distinguished by an IDENTITY COLUMN called “AttendanceID” which has an IDENTITY SEED of 1 and an IDENTITY increment of 1. However when I try to insert an attendance record to the table via my [...]
Answer Question
| May 11, 2012 2:54 AM
INSERT statement, SQL Server 2005, SQL Server 2005 Express Edition, VB.NET 2005
In my program I have an EmployeeRegistry table which holds data of each employee’s work attendance. Every attendance record is uniquely distinguished by an IDENTITY COLUMN called “AttendanceID” which has an IDENTITY SEED of 1 and an IDENTITY increment of 1. However when I try to insert an attendance record to the table via my [...]
Answer Question
| May 11, 2012 2:54 AM
INSERT statement, SQL Server 2005, SQL Server 2005 Express Edition, VB.NET 2005
Setup project force new file replacement on reinstall
Hello, I have a setup project that install a couple of projects and a couple of external files (one of which is a SQLite Database) – everything worked fine until i’ve recently modified the base database file included in the setup project. Now, every time i try to reinstall the project the new database file [...]
Answer Question
| January 11, 2010 3:38 PM
SQLite, Visual Studio, Visual Studio 2008, Windows Application
Hello, I have a setup project that install a couple of projects and a couple of external files (one of which is a SQLite Database) – everything worked fine until i’ve recently modified the base database file included in the setup project. Now, every time i try to reinstall the project the new database file [...]
Answer Question
| January 11, 2010 3:38 PM
SQLite, Visual Studio, Visual Studio 2008, Windows Application
Earn 250 Knowledge Points now by tweeting out our contest
We’ve recently added 250 Knowledge Points to the following profiles for tweeting out our Google Nexus One Challenge: Jaideepkhanduja OwenAmbrose Carlosdl Ryan8613 MarkK Tweet out our Google Nexus One Challenge now and you can also earn the 250 Knowledge Point bonus. Remember that you don’t have to be an expert to earn Knowledge Points in [...]
Answer Question
| January 27, 2011 3:23 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP Gateway
We’ve recently added 250 Knowledge Points to the following profiles for tweeting out our Google Nexus One Challenge: Jaideepkhanduja OwenAmbrose Carlosdl Ryan8613 MarkK Tweet out our Google Nexus One Challenge now and you can also earn the 250 Knowledge Point bonus. Remember that you don’t have to be an expert to earn Knowledge Points in [...]
Answer Question
| January 27, 2011 3:23 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP Gateway
Network engineer resume help
hello, i will be soon graduating with a bachelor degree of network engineering… so i was wondering if any one can help me about building my resume for job search. should i list all the protocols and stuff i learned or what? thanks guys!!
Answer Question
| January 14, 2010 7:48 PM
Careers, IT careers, Network engineering, Networking careers
hello, i will be soon graduating with a bachelor degree of network engineering… so i was wondering if any one can help me about building my resume for job search. should i list all the protocols and stuff i learned or what? thanks guys!!
Answer Question
| January 14, 2010 7:48 PM
Careers, IT careers, Network engineering, Networking careers
New Contest: Win the Nexus One Google Phone with your Knowledge Points!
You’re asking and answering questions already, so why not put those Knowledge Points to good use? Win a Nexus One, Google’s new cell phone! It’s unlocked, so you can sign on with the (select) carrier of your choice contract-free! Read all the details, but the short and long of it is that over the next [...]
Answer Question
| February 27, 2010 3:30 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
You’re asking and answering questions already, so why not put those Knowledge Points to good use? Win a Nexus One, Google’s new cell phone! It’s unlocked, so you can sign on with the (select) carrier of your choice contract-free! Read all the details, but the short and long of it is that over the next [...]
Answer Question
| February 27, 2010 3:30 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Migrate repository from SVN to VSS
hi experts, I just would like to know how to migrate the repository from svn to vss or svn to starteam As former case many suggests as bad idea in different forums,I am not familiar with those please guide me If any one is possibble,how can that be Migrated using what tools ?
Answer Question
| January 7, 2010 11:10 AM
SVN, SVN to VSS Migration, VSS
hi experts, I just would like to know how to migrate the repository from svn to vss or svn to starteam As former case many suggests as bad idea in different forums,I am not familiar with those please guide me If any one is possibble,how can that be Migrated using what tools ?
Answer Question
| January 7, 2010 11:10 AM
SVN, SVN to VSS Migration, VSS
updating char
update operator set ascii(REVOKFLG)=’0′ where login like ‘ospprov’ error missing equal sign.
Answer Question
| January 6, 2010 11:59 AM
ASCII, UPDATE statement
update operator set ascii(REVOKFLG)=’0′ where login like ‘ospprov’ error missing equal sign.
Answer Question
| January 6, 2010 11:59 AM
ASCII, UPDATE statement
updating char in Oracle 10g
how do you update a char in 10g
Answer Question
| January 5, 2010 11:37 AM
Oracle 10g, Oracle Statements, UPDATE statement
how do you update a char in 10g
Answer Question
| January 5, 2010 11:37 AM
Oracle 10g, Oracle Statements, UPDATE statement
GAMBAS – as front-end of open dbase?
hi..greetings to all i am an IT student and i am here to seek help. I am using UNIX OS. edubuntu v9 to be specific. and we ar eought to make a databe having gambas(if your familira wiht it) as front and dbase as the physical storage..how is this possible. last year we created a [...]
Answer Question
| January 14, 2010 6:52 AM
Database, gambas, gambas 2, gambas databasing, Software engineering, Unix OS, water billing systems
hi..greetings to all i am an IT student and i am here to seek help. I am using UNIX OS. edubuntu v9 to be specific. and we ar eought to make a databe having gambas(if your familira wiht it) as front and dbase as the physical storage..how is this possible. last year we created a [...]
Answer Question
| January 14, 2010 6:52 AM
Database, gambas, gambas 2, gambas databasing, Software engineering, Unix OS, water billing systems
Help with Database Structure
I need to create a databse that keep track of a Item # and associated with that Item# is 2 type of people. DonorID and OwnerID. Both these type of people i want listed in the same Table. So far my structure looks like so. [strong]tblItems [/strong] [strong] tblPerson[/strong] Item# PersonID(want linked to DonorID & OwnerID) Description LastName DonorID([em]dropdownList[/em]) FirstName [...]
Answer Question
| January 7, 2010 5:19 PM
Access 2007, Database design, Database structure
I need to create a databse that keep track of a Item # and associated with that Item# is 2 type of people. DonorID and OwnerID. Both these type of people i want listed in the same Table. So far my structure looks like so. [strong]tblItems [/strong] [strong] tblPerson[/strong] Item# PersonID(want linked to DonorID & OwnerID) Description LastName DonorID([em]dropdownList[/em]) FirstName [...]
Answer Question
| January 7, 2010 5:19 PM
Access 2007, Database design, Database structure
AS400 Query Join
I need expert help. I need to create a query that will use four tables. Each table has a column of data that I need for the report. The end result should display the following: Name, City, Amount, Reason. Here is my first query that gives me the name and city: SELECT “T16.GNAM”.N_NAME, “T16.GNAM”.N_CITY FROM [...]
Answer Question
| December 31, 2009 5:45 PM
AS/400 Query, JOIN, JOIN statement
I need expert help. I need to create a query that will use four tables. Each table has a column of data that I need for the report. The end result should display the following: Name, City, Amount, Reason. Here is my first query that gives me the name and city: SELECT “T16.GNAM”.N_NAME, “T16.GNAM”.N_CITY FROM [...]
Answer Question
| December 31, 2009 5:45 PM
AS/400 Query, JOIN, JOIN statement
Oppurinities in IT field
HI there, I am Dilip, Having 6 years Experience in ISP Company, working as a Assistant manager. I have done he CCNA,ITIL. and doing MBA (distance). I would like to Switch over to more specific carrier in IT…i like to work on more of managerial things and not on core networking.What would be the [...]
Answer Question
| December 30, 2009 6:59 AM
Careers, CCNA, IT careers, ITIL, Networking, Networking careers
HI there, I am Dilip, Having 6 years Experience in ISP Company, working as a Assistant manager. I have done he CCNA,ITIL. and doing MBA (distance). I would like to Switch over to more specific carrier in IT…i like to work on more of managerial things and not on core networking.What would be the [...]
Answer Question
| December 30, 2009 6:59 AM
Careers, CCNA, IT careers, ITIL, Networking, Networking careers
How should be through to get a cisco certified network job?
I am a desktop/pc technical support engineer with 7 years of work experience on windows os and basic network operations, now i want to be a network professional as it is my dream from my graduation. i am now certified with CCNA, i need help from you to get a job in this profession. how [...]
Answer Question
| January 7, 2010 11:35 PM
Careers, CCNA, Cisco certifications, Cisco Certified Network Associate, Cisco Certified Network Professional, IT careers, Networking careers
I am a desktop/pc technical support engineer with 7 years of work experience on windows os and basic network operations, now i want to be a network professional as it is my dream from my graduation. i am now certified with CCNA, i need help from you to get a job in this profession. how [...]
Answer Question
| January 7, 2010 11:35 PM
Careers, CCNA, Cisco certifications, Cisco Certified Network Associate, Cisco Certified Network Professional, IT careers, Networking careers
AS/400 Query Join
I am joining four files. Each file has one field I need for my report. How do I determine which file is the primary one? Should the select records criteria all come from the primary file? As long as I test fields First>Second, Second>Third, Third>Fourth, shouldn’t it work just fine?
Answer Question
| December 30, 2009 9:12 PM
AS/400 Query, JOIN statement
I am joining four files. Each file has one field I need for my report. How do I determine which file is the primary one? Should the select records criteria all come from the primary file? As long as I test fields First>Second, Second>Third, Third>Fourth, shouldn’t it work just fine?
Answer Question
| December 30, 2009 9:12 PM
AS/400 Query, JOIN statement
