Simple Stored Procedure

Hello,

Here comes a little dash of SQL at ya;

---
Brief explanation: This procedure returns all fields from the table "Users" based on
the parameter @userid, which is an integer type parameter
Input: @userid integer
Output: Resultset with user data
---

CREATE PROCEDURE dbo.sp_getUsers

@userid int

AS

BEGIN

SELECT * FROM Users WHERE id = @userid

END

---