• How to use Insert command between two servers to speed up performance

    We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the data got there....

    Studentofsql5 pointsBadges:
  • odbc in i5/OS

    I need to know how i can create an data source name or a odbc connection for a database in i5/OS. Kindly guide me.

    Jacky160 pointsBadges:
  • Access 2007 filters

    when i use the filter option and then go to advanced filter to save as a query. It is a ligth gray color and i cant click on save qurey. So i cant save any filters.

    Davobeau5610 pointsBadges:
  • Data retrieval from TextBox and insert in to database

    Hi i am learning c#2008 and asp.net3.5. I want to get data from my textbox control and insert it in database so i cant find any source code or presentation so please tell me how to do it or give me site address where i can find this Thanks

    Nimitparmar19875 pointsBadges:
  • DB2 to SQL Server migration

    We have a client that is migrating from the AS/400 DB2 to .NET and SQL Server and they want us to find them a resource to help locate and then migrate the data stored on the DB2 data base to SQL Server and I was wondering if that is more for a DB2 DBA or for an AS/400 Systems Analyst? Also, the...

    SolpartDean5 pointsBadges:
  • mysqldatetime exception

    mysqldatetime exception i am using MySql  with c# in my window application , In code i think everything is fine , when i made a latest patch for the given installer it throwing an exceptuon at client side " Cannot perform '<=' operation on MySql.Data.Types.MySqlDateTime and System.String." when...

    ITKE54,755 pointsBadges:
  • Create a LNotes DB replica for Unique ids only

    I have a LNotes DB which contains a field populated with a unique id number. I would like an action button to prompt the user for their IDNUm, then once entered it would replicate only those documents where the IDNums match from the server to a local copy. We are currently able to do this manually...

    IMLearning25 pointsBadges:
  • passing array as parameter to stored procedure in mysql

    how to passing array as parameter to stored procedure in mysql?

    Itprofession5 pointsBadges:
  • MySQLi and PHP problem with code

    Can someone please tell me what I'm doing wrong with this particular line of code. echo "<td colspan=3>{$Row['areaCode'] . '-' . $Row['prefix'] . '-' . $Row['lineNumber']}</td></tr>"; I know that the concatenation operator is the . 'areaCode' 'prefix' and 'lineNumber' are all...

    PatOswalt115 pointsBadges:
  • Retrieving data tables without backup SQL

    If I truncate a table without the backup of it, how do I retrieve the table data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • automatically populate field sequentially from list

    I created a form for assigning incoming projects to employees. I have a main table that includes the majority of the data relevant to the project and I have another table with just the employee’s names, work unit, and an auto id field. The main table also has the employee’s name and work unit....

    Jodibelle45 pointsBadges:
  • View a concise list of all Job Schedules SQL Server 2000

    I have an Optimisation job on my SQL platform (2000), which continually fails. I suspect the cause in that this job overlaps another, but without going through each job and checking the schedules I can't be sure. The number jobs I have makes this an onerous task. Is there a way to query the...

    Cyphersimian30 pointsBadges:
  • Access 2003 – Setting Form’s Recordsource

    Hi I have a SQL query which I know works.  I tested it by creating a pass-thru query in Access and running the query below: SELECT PcSd.PRICE_SCHEDULE_ID, CASE WHEN PcSd.PRICE_LEVEL_CD IN ('BGA', 'BNG') THEN 'Brand' ELSE 'Generic' End As Price_Level, PcSd.PRICE_TYPE_CD, PcSd.DISPENSE_FEE_AMT,...

    JK012450 pointsBadges:
  • MS Access query to show records that contain dates that differ by 1 year

    I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a time. To create a datediff function for all...

    SerenityNow365 pointsBadges:
  • Generating Contracts Documents Automatically in Microsoft Access

    I am in a project that is expected to build a Contracts system.. The idea is that because of standard format of contracts documents (Schedules , amendment, letter.. etc), the system is supposed to use these standards documents to generate customized contracts, edit them, provide choices of some...

    MuathBinhussain10 pointsBadges:
  • Joining 2 tables in MS Access and Searching & Retrieving records using ComboBox in VB and ADODC control

    How can I join 2 tables in MS Access (e.g,tbl1 and tbl2)and Searching & Retrieving records using ComboBox and will display in a textbox after i click Search button in VB? I am using ADODC control as datasource

    Pisceaneffect5 pointsBadges:
  • In-Memory Processing Storage options

    Is "in-memory"processing a reality? I am researching the viability of  IMDS (IN-MEMORY DATABASE SYSTEM).  RDBMs is rapid failing its ability to storage the data receive.  This is just in the discussion stage.  I am looking for evidence that is a viable possiblity in today's business world.  

    Twolittlehorses4me10 pointsBadges:
  • Monitoring Object changes in Oracle

    I have to find out who modified objects in dba_objects each week for those changed during that week for SOX perspective. Right now i check with deveplopers for each one, which they don't like. I question is how to find out who modified an object in 9i or 10g (and 11i)?

    QAQA65 pointsBadges:
  • QMF results display as Excel sheet (line feed characters within data fields)

    When displaying QMF (V8.1) Query Results as an Excel spreadsheet, the Line control X'0A' characters within the data fields are causing: fields to split (multiple fields) where the where the LineControl characters occur and, the field and record to be continued [strong][em]on the following...

    Girwin505 pointsBadges:
  • SQL for Microsoft Access

    I have crated the below SQL statement. I works fine. and it gives me the required "RTCDate" I need, that which is difined at the Where statement of 3 - 2010. The other constraints are that I need all my 79 product line numbers. and the "1" is those product line numbers that are active...

    CompEng1,185 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following