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

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

    Bulk Insert can't handle eof marker

    I need some help with this problem it's driving me crazy. I have a Bulk Insert statement which uses a format file. Everything works fine except the application I'm exporting the text file from creates a eof marker at the end of the text file. This cause the Bulk Insert to fail with an...
  2. stanky23

    Dynamic Cursor Problem

    I'm having a bit of a problem using a dynamic cursor where I update the underlying data but the cursor does not show the update on the second fetch. Although books can be incorrect the following sysntax is just as it is shown in the book I have: If original value of flag is 'A' Declare @date...
  3. stanky23

    Foreign Key Issue

    If you look at the properties of a foreign key relationship in a diagram there is a check box for "Enforce Relationship for Inserts and Updates."When I do a CREATE TABLE and add a foreign key constraint I want to have this box unchecked. In my Create I include ON UPDATE NO ACTION, ON...

Part and Inventory Search

Back
Top