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 Mike Lewis 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: fvlo
  • Order by date
  1. fvlo

    How do I import a physical file with XML-data into MS-SQL?

    I want to import data coming from another system into my SQL-database. This data is in XML-format in a physical file and this file can be very big. I have searched the internet and MSDN but cannot find a way to do that from within a SQL-procedure. Can anyone tell me how I should do this or...
  2. fvlo

    multi-column index question

    Hi there, I have a question about indexes. I have an index on say 4 columns: A, B, C, D Do I need to create a new index on columns A, B, D if I would frequently need to update the table using columns A, B and D or does SQL-Server use the first index?
  3. fvlo

    String Manipulation problem.

    You could try something like this: ----------------------------------------------------------- CREATE FUNCTION GetListItem ( @List VARCHAR(4000) --the @Delimiter-separated list of items ,@Nr INT --the x-th item that should be retrieved ,@Delimiter VARCHAR(10) --the delimiter. Can be...
  4. fvlo

    Trigger on many rows does not end

    Thanks for the suggestion, but I have recursive triggers set off.
  5. fvlo

    Trigger on many rows does not end

    Hello, Facts: 200.000 records are inserted in a table. This table has a trigger on it which modifies a datacolumn if a condition is TRUE. The trigger works fine with 1.000 records and even with 10.000 records (though slowing down). Problem: If 200.000 records are supplied to the trigger, it...

Part and Inventory Search

Back
Top