Information générale
Forum:
Microsoft SQL Server
>>Well, in Oracle it would be done like this:
>>
>>CREATE OR REPLACE VIEW MyView (ParaVar IN SomeTable.Field1%TYPE)
>>IS
>>SELECT Field1, Field2
>> FROM SomeTable
>> WHERE Field1 = Paravar;
>>
>>where paravar is the parameter you want to pass into the view. In SQL Server, I haven't the slightest idea.
>
>Hi Gregg!
>Actually I remember Oracle doing this, I was out to compare SQL Server Views to Oracle Views.
>
>From as far as I can tell, the only way to simulate what we're used to with parameterized VFP views in SQL Server is with a Stored Proc called via SPT
Hi Roxanne,
I have a lot of studying to do to get ready for this. Do you have any books that you'd recommend for studying SQL Server? I need to send off for their time delimited version of SQL Server so I can get some hands-on time with the product. A fellow at our VFP users group in Kansas City said he was able to pass the SQL Server test (but just barely) after a measure of "book larnin" without ever having developed anything with it. I'd rather get into it a little deeper than that. Have you built anything using an SQL Server back end?
Ciao,
Gregg
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