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 bkrike 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: tsinvr
  • Content: Threads
  • Order by date
  1. tsinvr

    What does the N do in sp_attach_db?

    This is probably a silly question, but I can not find the answer. In the sp_attach_db command the books on line samples show that you put an N infront of variables, like this: EXEC sp_attach_db @dbname = N'FIRE', @filename1 = N'c:\Fire_RMS\FIRE.mdf' What does the N mean? Thanks. Ted
  2. tsinvr

    Return unique values - where item is only used

    I am trying to figure this out, and after banging my head against the wall for a few hours I thought I would ask to see if there is something I am missing. Scenario: Table icfct holds transactions. A sample list of rows would look like this: Row_ID Part_ID Program_ID 872...
  3. tsinvr

    Reading Excel file - text cut-off

    I have a utility that needs to read an Excel data file. I have the system working pretty well except that it will not read long notes. Any note that is longer than 255 characters gets cut-off. I am using VB6 and using an oledb connection to Excel: cnnExcel.Open...
  4. tsinvr

    Readonly recordset is causing record locks - How to fix?

    I have a program that is reading one database and based on the results will update a seperate database. My reads are supposed to be readonly but it is being reported to me that this is causing recordlocks on the server that is blocking other processes. here is a snipit of code: With oSLXRS...

Part and Inventory Search

Back
Top