Thanks Dave I'll study this example Rafael ----- Original Message ----- From: "Dave Crozier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 19, 2008 7:00 AM Subject: RE: stored procedures in SQL
> Raphael, > Sorry, pressed Send too quickly. > > Calvin has an example of creating a Stored Procedure on SQL Express in > VFP: > > http://blogs.msdn.com/calvin_hsia/archive/2006/05/19/602089.aspx > > Dave Crozier > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Rafael Copquin > Sent: 19 November 2008 00:19 > To: Profox > Subject: stored procedures in SQL > > Perhaps this qualifies as NF, but then, it is a pure VFP question. > > I am doing my first steps in SQL Server, using SQL Server 2005 Express > edition. I just want to create a stored procedure in SQL Server, so I can > do the following: > > Create a connection in a VFP form > call the stored procedure (passing for instance a customer PK), so the > procedure will return the customer name, address, email, etc. > > A very simple sql call. > > But how do you create the procedure in the SQL engine? Or should I ask > this > question in a SQL forum? > > TIA > > Rafael Copquin > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
