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.
