Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mkey

  1. mkey

    pl/sql vs sql server procedures

    Hi all, In oracle when we wright stored procedures the language is called pl/sql. when we write a stored procedure in sql server what is the lanugage? Is it just called SQL? Thanks!
  2. mkey

    SQL Server 7.0

    Hi all, Like in Oracle 8i database server where we have a utility called DBA Studio to administor database and its users, what is the utility for SQL Server 7.0?
  3. mkey

    load data

    Hi all, I have never loaded data into SQL Server 2000. I have a dumpfile with a .bak extension. I need to load the data into a database. What is the process? Thanks!
  4. mkey

    ODBC failed error,urgent!

    The error message no is: ODBC – call failed. (Error 3146)
  5. mkey

    ODBC failed error,urgent!

    HI all, I have microsoft access 2000 and import table from microsoft excel. Now I'm trying export the table into Oracle 8.1.7 but I keep getting the ODBC error. However using the same ODBC I could connect to the Oracle database and link tables. What is going on?
  6. mkey

    trigger question

    Hi all, Why we use REFERENCING in a trigger? The following trigger contains the REFERENCING clause: CREATE OR REPLACE TRIGGER C_BIR BEFORE INSERT ON schema.c_table REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW BEGIN SELECT c_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL; END; / What does the...
  7. mkey

    add a primary key and foreign key

    Thank you all!
  8. mkey

    add a primary key and foreign key

    Hi all, How can you add a primary key to an existing table? The structure is like this: CREATE TABLE [dbo].[TEST1] ( [ID] [int] NULL , [NAME] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) Now I need to modify the test1 table so that ID column will be the Primary key? Also how can...
  9. mkey

    import data from Oracle 8i and constraints lost

    Hi, Thank you for the response. NOw how can I set up the DTS so that I can import all the constraints? Thanks!
  10. mkey

    import data from Oracle 8i and constraints lost

    Hi all, One of our clients complained that when they imported data from Oracle 8i to SQL Server 2000 the constraints got lost. Is this possible? Thanks!
  11. mkey

    PVCS traker

    Has Anyone used PVCS Traker? We have the tracker installed in the one of the computers. It used the SQL Server as the backend. But I'm not sure where all the data files are save. Thanks!
  12. mkey

    sql script help

    HI all, Logic of the script is listed below. Now I'm not sure if I could do this with a SQL or I have to write PL/SQL. Anyway this is how the script looks like: SELECT one_step_before_Last(STATION_POINT.MEASURE) AS LastOfMEASURE, one_step_before_Last(COORDINATE.X_COORD) AS LastOfX_COORD...
  13. mkey

    Updating in microsoft 2000n,urgent

    Thanks jj. It works now! Thank you so much:)
  14. mkey

    Updating in microsoft 2000n,urgent

    Th id field has NO pk key. However it doesn't accept nulls. The odbc driver i'm using is Oracle ODBC Driver 8.1.7.0
  15. mkey

    This recordset is not updateable

    Hi all, I have linked a table that is in Oracle 8.1.7 through access 2000. I realized its not an access forum, but I think someone might have experiance this problem one time or another. Well the problem is I linked the table though the access gateway. When I try to update the id column to...
See more

Part and Inventory Search

Back
Top