How would you write the “Where” clause (sql) for abstracting just the “Year” out of a startdate like 03/12/2013 which would result in an answer of “2013″?
Answer Question | May 21, 2013 2:29 PM
Database Management Systems
im an it student from tanzania currently im an intern in one of the united nation org. but im only doing user support activities. but i want to build my carrier in database management may u give me some advice on where to start and what to study. ms ashura from tanzania
Answer Question | March 6, 2012 6:07 AM
Database management, Database Management Systems, IT careers
from a excel database with say 300 names, I would like to click a button to choose the names and quantities to generate a custom vdp database.
Answer Question | December 21, 2010 12:17 AM
Database Management Systems, Excel Database
I want to set up a database internally and archive data
Answer Question | October 20, 2010 3:00 PM
Database management, Database Management Systems, Database Triggers, DBMS
I would just like to ask what the best database management system is right now? Especially for a new company or business. Just really something easy for endusers. What will you recommend for me? Thank You!
Answer Question | October 1, 2010 3:15 PM
Database management, Database Management Systems, DBMS
Why is it when one certain user is in the DBASE no one else can get in – but when everyone else is in and this user isn’t, she still is able to get in – all our settings are the same – Shared, no locks and the open database by using record-leveli locking is unchecked, [...]
Answer Question | August 21, 2010 1:17 PM
Database management, Database Management Systems, dBASE, DBMS, Windows XP
Hello Everyone, I am .net developer, my more interest into DB , Abinitio, BI, Informatica.Can anyone suggest me better option for me with further prospects?
Answer Question | October 23, 2010 5:52 AM
Database Management Systems, Informatica, IT career, SAP BI Consultant
A COMPARISON OF DATA WAREHOUSE SCHEMA DESIGN VERSUS CONVENTIONAL RELATIONAL DATABASE DESIGN. (2000 NEEDED)
Answer Question | May 19, 2010 9:44 PM
Database Management Systems, Database schema, Relational databases
what are the advantages and disavantages of database management system
Answer Question | May 5, 2010 2:46 PM
Database Management Systems
Hi all, How to transfer datas from one database which has completelly different structure to other datebase with different structure? How to map these database? Is there any tool which does this? If so please suggest some free tool. Please help. Thank you all in advance.
Answer Question | October 15, 2009 5:56 AM
Database Management Systems, Database migration
I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the Trigger coding? [...]
Answer Question | September 16, 2009 6:18 PM
Database Management Systems, SQL Server, SQL Server 2005
What is the user-name and password of Oracle 6i to Log in?
Answer Question | July 28, 2009 5:06 AM
Database Management Systems, Oracle 6i
I am interested in making software that allows potential employees to find employers who are offering what they are looking for in a job (be it salary, benefits, location, a specific job, etc). I also would like to have the vice versa of the scenario where the employer can look for a specific type of [...]
Answer Question | July 1, 2009 8:14 PM
Database, Database Management Systems, Software development
I have been tasked with doing some comparisons/making some recommendations for a good system to handle a small (but growing) business. I have personal experience with Remedy, Commit,and (an in-house program that I cannot remember the name of) but would like to find something very user friendly, with plenty of reporting features. Any input/suggestions would [...]
Answer Question | June 9, 2009 2:03 AM
CRM, CRM software, Database Management Systems
What do you think will be the implications of Oracle’s Sun acquisition on: The future of MySql ? The virtualization market ? The hardware market ? The operating systems market ? Other IT fields ?
Answer Question | October 29, 2009 12:35 AM
Database Management Systems, Hardware, Operating systems, Oracle, Sun Microsystems, Virtualization
what are the basic steps in implementing a database management system?
Answer Question | March 24, 2009 4:50 AM
Database Management Systems, DBMS
I want to create a sample database for a company with employee of 5000+. The employee data will include name, address phone etc. and also have photograph of each employee. In addition, I want to create a list of meeting that some managers have attended and the issue that they have raised during the meeting. [...]
Answer Question | March 7, 2009 9:21 PM
Database Management Systems, Database software
We are a non-profit buying group with 3 persons in our office. We need a contact data base that can be shared including on the fly changes. We have a network, but no dedicated server. We currently are using Act 6.0, but that is getting old and problem riddled. Is there a web based contacts [...]
Answer Question | November 25, 2008 6:43 PM
ACT, Database Management Systems, Microsoft Office
Which mac would be best to use for statistical analysis using SPSS? I know that most PCs make this easy with WIndow and MS Access as db, but I have a house and office filled with Macs – only other option is to add a PC. Thanks!
Answer Question | November 21, 2008 8:22 PM
Database Management Systems, Mac, SPSS, SPSS 17, SPSS Compatibility with Mac
Is there a way to use MS Access to interface with a database that uses EDI? If so, what do I need to do to do this & where can I get more info on this?
Answer Question | November 11, 2008 1:32 PM
Access, Database Management Systems, DBMS, EDI, Electronic Data Interchange, Microsoft Access