If I'm understanding your question correctly, stored procs are written in some form of SQL or T-SQL and look amazingly like what you're used to with VFP, with some minor 'packaging' around them.

USE [database]

(Create)
ALTER PROCEDURE [dbo].[ProcName]
@UserName varchar(25),
@Name varchar(75) output,
@Phone varchar(15) output,
@Ext varchar(10) output,
@Email varchar(100) output

AS
BEGIN
SET NOCOUNT ON;
select @Name = ltrim(rtrim(first_name)) + ' ' + ltrim(rtrim(last_name)),
@Phone = substring(Phone,1,3) + '-' + SUBSTRING(Phone, 4,3) + '-' + substring(phone,7,4),
@Ext = Ext,
@Email = email
from tablename
where UserName = @UserName

END

That's a very simple stored proc. Others can get quite involved


>Kinda a random question but it has crossed my mind as I have worked through the many posts - what are stored procedures written in when they are contained within SQL Server or PostgreSQL server? I would assume it is some sort of function call that runs some sort of script?
>
>Albert