Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement