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 TouchToneTommy 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: *

  • Users: bschmitz
  • Content: Threads
  • Order by date
  1. bschmitz

    Alter an INT field to be Identity

    I have an integer field with data that I am trying to change to the Identity field without losing any data. I have to do this using the osql utility. When I run the statement "Alter table table_name alter column column_name int identity", I get the following error "Incorrect...
  2. bschmitz

    osql utility

    Can anyone point me in a direction as to how to import data from either a text file or a spreadsheet into an existing SQL table using the osql utility. Thanks in advance!
  3. bschmitz

    opening a .dat file

    I was sent a .dat file and have tried to open it with EM using both the Import data wizard and the restore DB wizard but neither wizard gives me a source option of .dat. Is this possible? Am I doing something wrong? Thanks in advance for your help.
  4. bschmitz

    insert parts of string into 5 columns

    I have a 1000 character field in a table. I need to pull out different parts of the string from each record and insert them into different columns in a new table. I was thinking that I would create a DTS package to do this. I am new to SQL and find myself struggling with this. Thanks for the...
  5. bschmitz

    SQL2000-'Where' clause as input parameter??

    I am trying to create a stored procedure that accepts the 'where' clause as an input parameter. I cannot get SQL to recognize the variable as part of the syntax of the stored procedure. The 'where' clause can be different everytime. As in "WHERE SlprsnId = '1234' AND DocNmbr =...

Part and Inventory Search

Back
Top