Certainly, you can scan and manipulate the result set.

I usually just Google whatever I'm looking for like "SQL Create Cursor" or whatever. You might also want to look at something like W3Schools online. They have a set of SQL tutorials which are rather simplistic, but will get you started




>Hi,
>
>Sorry for the delay in responding...holidays and then "fires" to put out once back at it.
>
>What would I search for to look up the syntax for the stored procedure language? And short question would be, other than creating a query, does the language have the ability to scan the result set or anything?
>
>Thanks.
>
>Albert
>
>>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