1
  • Adding a field when using SQL to copy a file on iSeries

    My company is upgrading some applications and I need to copy the data from current files into the new files. In some cases the new files have additional fields. Is there a way with sql to copy the current data and at the same time add either a default value or a running sequentional value to the...

    CLK35 pointsBadges:
  • Use SQL INSERT to Create Directories with FileTable

    This is my first experience with SQL Server 2012 and I'm not familiar with the limits of the FileTable from within SQL Server. Is there a way to create directories in a FileTable without using File I/O APIs? Is it just as simple as creating a SQL INSERT statement?

    ITKE341,745 pointsBadges:
  • Trigger over table that uses transaction inserts

    I have a table that is being updated via JDBC. The program that is writing records (sql insert) is using transactions. This table has an after insert trigger on it. When the trigger is disabled the table is updates correctly. When the trigger is on we get the first record and the tigger locks the...

    KSC90 pointsBadges:
  • Select into vs Insert into in SQL Server

    Hi experts, What is better between Select into vs Insert into in SQL Server when it comes to performance? thx

    DBM10 pointsBadges:
  • Bulk Insert Problem in SQL Server Management Studio 2005

    Hi. I'm running into an issue performing a bulk insert. I've taken the following steps: Created a tableCreated a schema file with a .fmt extensionCreated a stored procedure to insert a file When I attempt the bulk insert I get the following error message: Cannot bulk load because the file...

    Eabouzeid175 pointsBadges:
  • SQL auto increment by group with INSERT..

    Is it possible to define an auto-incremental coloumn which increments by 'group' ? I want to create a version log for an old table (uniquely keyed 'HOWTONO') which contains records with 'How to' data in the form of short code-fields and some long fields with text.  I intend to trigger updates,...

    DanTheDane2,555 pointsBadges:
  • help on Bulk insert and xp_cmdshell rename

    Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows.I dont have a delimiter. csv file: (First row is blank) apple bat cat doll when i used the below command BULK...

    GIG240 pointsBadges:
1

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following