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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sqlskrathan

    How to supply next value to the surrogate Key inSQL Server

    Hi, I like to know how to populate a sequence number for the surrogate key in MS SQL Server. I have tried with the KeyMgtGetNextValue and @INROWNUM but both didn't work correctly for surrogate key. Do we have a sequencer in MS SQL Server so that we can start the sequence and increment that...
  2. sqlskrathan

    Load storedprocedure with parameter into datastage

    Hi, I am working on Ascential Datastage with SQL Server 2000 I have problem with a stored procedure. I am trying to use a Stored Procedure into my ODBC Stage and pass one "job parameter" value into the stored procedure but, It gives below error "Error: The name must begin with...
  3. sqlskrathan

    load Stored procedure with a parameter into DataStage

    Hi, I trying to load Stored prcedure which accepts one argument into DATASTAGE. While I was importing It asked for the argument value and when I given a value to it , It loaded the stored procedure into the DATASTAGE but no data to view. Please if anybody know how to load the Stored...
  4. sqlskrathan

    load stored procedure in DataStage from MS SQL server with a parameter

    Hi, I trying to load Stored prcedure which accepts one argument into DATASTAGE. While I was importing It asked for the argument value and when I given a value to it , It loaded the stored procedure into the DATASTAGE but no data to view. Please if anybody know how to load the Stored...

Part and Inventory Search

Back
Top