Stored Procedures-Help

[udit99]

I don't know how to create stored procedures---Can any1 help me ?
I need to access some records off a table-> employeeInfo and use them to populate the recordset. Now how would I create a store prod. to do the same.

earlier I used 2 do it with an SQL stmt--

"select * from employeeInfo"

[Bigley]

Firstly I hope your DB supports SPs. And if it does you will need to write some T-SQL as follows

Create Procedure FindMatchByID (@ID Integer) as

SELECT * from myTable
Where ID = @ID

Then execute this t-SQL against the appropriate database through your query analyser.

And when you refresh your SP list it will be there.

HTH