Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Executing Stored Procs With Params
Message
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
00979533
Message ID:
00979702
Views:
21
Thanks. This will give me plenty to chew on!



>Kevin,
>
>Here's a very simple stored proc to return the entire customer record for a customer PK...
>
>
>CREATE PROCEDURE GetCustomerByPK (@nCustomerPK int)
> AS
>
>	SELECT * FROM Customer WHERE CustomerPK = @nCustomerPK
>GO
>
>
>You may want to check BOL (books online) for more details on creating SPs.
>
>Kevin
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Reply
Map
View

Click here to load this message in the networking platform