Need help on stored procedure

[sirajcuet]

Dear all
i need a sample code in stored procedure so that i can start
it will be better for me if i get the code on crystal report+vb+sql/access

waiting for the sample


siraj

[Madhi]

SQL Server

Create Procedure myProc as
Select * from yourTable

[jason79]

hey, a simple stored procedure on sql server would be -

Create Procedure GetNameInfoById
(
@Id int
)
As
SELECT first_name, last_name
FROM sample
WHERE id = @Id

where 'Id' is an input variable on type integer.

Hope this helps.
J.