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 Wanet Telecoms Ltd 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. besabe

    Exclude Columns when select * into table. how?

    Hello JMCraig, Thanks for your response, you not help so much. In fact I already discard the middle-ware, for cost reason. And yes, there is a way to create "dynamic" sql, I did it and works fine, my limitation it’s the 255 char in the string definition. FYI, Bcp utility works for...
  2. besabe

    Exclude Columns when select * into table. how?

    Hi, I also did it, "text" dtatype is not valid in the sp. what ever ideas is good to know. Saludos
  3. besabe

    Exclude Columns when select * into table. how?

    Hello JeanNiBee, Let me explain. I have a list of tables that need to be imported every day. Im using the BCP utility and then export the data into Oracle. Not all the columns are required to be imported. In order to use the BCP I have 2 options: 1: Create the tables with the columns required...
  4. besabe

    Exclude Columns when select * into table. how?

    Hello JeanNiBee, Thanks for you response. What I want it is more dynamic. I know that I can specify the column list instead of the *. But the way that it try to do, is based on a exclude column list. I want the sp to write for me automatically the select list. For example, I can go to...
  5. besabe

    Exclude Columns when select * into table. how?

    I need to create a dynamic sp in order to create temporal tables using the EXEcuted statement creating a string cmd: exec @cmd = ('select * into from' + @tabname) But I need to exclude some columns to not include into the new temp table. I already have a TableList in wich I specify the Exclude...

Part and Inventory Search

Back
Top