|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
extended proceduresI'm finding lots of code samples for writing extended procs, but *all* of
them do nothing with SQL. Hello or calculating free disk space are common examples. I'm writing a sp because I want to work with SQL data. How do I do that from an xp? Do I have to go back around through ADO? I would think that ODS would have a method in the API to interact with the data, but you can't tell that from the sample code I've found so far. -- Thanks, Brad. Normally an XP will perform functions that aren't available (or aren't fast
enough) via standard T-SQL. If all you want to do is execute standard T-SQL statements against your database, you probably want to write a regular SP. Show quoteHide quote "Brad White" <bwhite at inebraska . com> wrote in message news:%23v1TOVwYFHA.3132@TK2MSFTNGP09.phx.gbl... > I'm finding lots of code samples for writing extended procs, but *all* of > them > do nothing with SQL. Hello or calculating free disk space are common > examples. > I'm writing a sp because I want to work with SQL data. How do I do > that from an xp? > Do I have to go back around through ADO? > I would think that ODS would have a method in the API to interact with > the data, but you can't tell that from the sample code I've found so far. > > -- > Thanks, > Brad. > > >  
Other interesting topics
Return always 0.
Hoping not everyone is gone the Friday before Memorial Day! Implementing natural keys Recursive rows in table and deletion problem Newbie: UPDATE a Table Centralizing Two Stored Procedure Queries (one using Cursor Output Drop all indexes partitioned view goofiness how to aduit database access? "Insufficient key column information for updating and refreshing" |
|||||||||||||||||||||||
