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

    Determine Column Names from a dynamic SQL statement in TSQL

    Greetings, I have a stored procedure that accepts a dynamic sql statement, and I need a way to determine the column names of the recordset generated by this sql statement. (Easy enough to do with ADO using the myRS.Fields collection, but I would like to do this entirely in my stored procedure.)...
  2. Funka

    Retrieving related records with a Minimum of Database Activity

    hello! i am adding in contact management features to an application. Each Contact can have multiple roles in her origanization. there are two tables involved. (a third table is a lookup/results table, but that is not important to show). CREATE TABLE Contacts ( ContactID int ...
  3. Funka

    Retrieving related records with a Minimum of Database Activity

    hello! i am adding in contact management features to an application. Each Contact can have multiple roles in her origanization. there are two tables involved. (a third table is a lookup/results table, but that is not important to show). CREATE TABLE Contacts ( ContactID int ...
  4. Funka

    Spellcheck form submission

    hello all! i am wondering how to go about spellchecking text fields submitted from a form. i read a suggestion on using MS Word to do the checking, but am not sure how to go about this. what other methods exist for spell check? any components available? thank you for your replies. -f!
  5. Funka

    Indexed View and accessing base tables

    (SQL Server 2000 Enterprise) i have created an indexed view joining two base tables: this view was created with ANSI_NULLS and QUOTED_IDENTIFIER set to on. the view works great, but client applications immediately receive errors on stored procedures which access the base tables. these stored...
  6. Funka

    implementing a FIFO stack

    hello! i am wondering what is the fastest, most efficient way to implement a FIFO stack in SQL Server 7...? for example, i have a table called ActiveTasks, and need stored procedures to read/remove the topmost Task, and then another which adds a new task to the bottom of the stack. i have been...
  7. Funka

    "checking out" a record - selecting, locking, and updating

    We are trying to implement a system for "checking out" records from our SQL Server 7.0 database. In this distributed application, the client machine needs to select an available record from tblSpool (where the record's Status is -1) and then set its status to 0 to indicate that it has...

Part and Inventory Search

Back
Top