Hi Bill,
One of the speakers at SQL Connections gave a session on that subject. I know you were there, so look through your conference materials and/or CDs (did you pay to get the SQL materials?).
Also, pretty much any SQL book goes into SPs that accept parameters and update data. Inside SQL Server 7.0 does.
>Agreed. What I've been trying to figure out lately, is how to manage updates via stored procedures (SQL Server and Oracle). It's been said, but I've never figured out HOW, that all updates could be accomplished via SPs. Do you know of any references where that could be explained further?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05