General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
OS:
Windows Server 2012 R2
Network:
Windows Server 2012 R2
Virtual environment:
VMWare
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only