• How to check the existence of a Column in SQL Server 2000?

    - using SQL Server 2000 , Would like to know how to check any specific column exist in a database. Any method to search through the list of tables in a database. Thanks.

    Hunkgym5 pointsBadges:
  • inventory

    what kind of DBMS do i need for inventory

    Rookie2learn10 pointsBadges:
  • Microsoft Access 2007 Data Input & Report

    I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 V V With the 3 pieces of information...

    PD15 pointsBadges:
  • What should our next contest be on ITKnowledgeExchange.com?

    We want to kick off the new year with an exciting contest and want your input. We have done a variety of contests from the top 3 Knowledge Point earners winning prizes like an XBOX 360. Also we have had Amazon.com gift cards for the top 10 point earners who achieve over 500 Knowledge Points. I want...

    ITKE409,365 pointsBadges:
  • DB2 SQL Confusion

    I am failing to understand why the following won't work SELECT m.index, SUM(d1.amt), SUM(d2.amt) FROM master m, detail d1, detail d2 WHERE m.index = d1.index AND m.index = d2.index AND d2.qalif = 1 GROUP BY m.index I wrote another sql that does work, I just don't understand why I get higher values...

    ThorButtox5 pointsBadges:
  • Export Access to Outlook

    Is there a simple way to export an Access Database to Outlook? There seems to be an export to Lotus 123 but not one for Outlook, am I missing something?

    Msquared1110 pointsBadges:
  • Slow JDBC DB2 Connection

    Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the...

    Biohazard425 pointsBadges:
  • AS/400 definitions and Password Change Century

    AS400 is new to me and i realy need help... I have 4 questions :) 1. What is the meaning when i see '1' on the column of 'Password Change Century'? 2. How can i see if ODBC is in use in AS400 and if it is in use, how can i see relevant definitions. 3. How can i see if DDM is in use in AS400 and if...

    AS400 - Ask the Expert485 pointsBadges:
  • Look at query results & pass a value to form in ACCESS 2003

    I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the same part...

    Rbrown3805985 pointsBadges:
  • Crystal Reports can’t connect to Access 2007

    We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB's. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB's.

    Rcsully6515 pointsBadges:
  • AS400/iSeries Queries on a schedule

    I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.

    Querys100 pointsBadges:
  • Code to upload CSV file to AS400

    I am looking for code to convert .CSV file to AS400 automatically. I need to automate this feature. Thanks in advance.

    Jazzcafe5 pointsBadges:
  • Clustering

    I am using Oracle 10g on Windows I would like create clustes for faster reterival. How can I create it(syntax) can you help me with an example. How does it effect the performance

    Vishwanathavn5 pointsBadges:
  • Setting run priority on prestart jobs

    We have several applications that query the iSeries through ODBC, so they all use the prestart job QZDAINIT. Is there a way to change the run priority on these jobs so that one application's queries can have a higher priority than another application's queries? Since each application's queries...

    GaryF60 pointsBadges:
  • Access Database – Colorize one word or letter

    How do I colorize one character in a field in a table? I want the letter "O" to be in red for one customer and blue for another customer in the same column but different rows.

    BethG5 pointsBadges:
  • Reporting problem when dates contain zeros in the same field

    Using AcuODBC and creating simple lists involving dates, ie, termination date in an employee file. When I select only records that (in this case) do NOT have a valid date in the TERM-DAT I select no records at all. The data is a signed decimal 8 characters with a valid sign. Crystal seems to not...

    Jelvis5 pointsBadges:
  • Database connectivity using ActiveX control

    Provide a sample code to how by using VB 6.0 connectivity can be done by ActiveX(ADO) Control tool with the database SQL Server 2000

    Reena10 pointsBadges:
  • Database connectivity using Data Control

    Provide a sample code to how by using VB 6.0 connectivity can be done by Daat Control tool with the database SQL Server 2000

    Reena10 pointsBadges:
  • Correct Isolation level for SQL2005 Subscriber.

    Hello, I'm specifying a SQL 2005 Enterprise back-end to an OLTP application which has one main DB (200GB, could grow to 600GB), a subset of which will be replicated to a separate subscriber for running read-only queries. Here's the spec, any comments appreciated, especially around the use of read...

    SuperCoolMoss140 pointsBadges:
  • What are the drawbacks of these two techniques of Change Data Capture?

    Hi can anyone tell me the draw backs of these two techniques of change data capture? 1: Table Differencing 2: Change-Value Selection

    Mahr5 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.

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

Following