Value Back from Stored Procedure

Question

I create a table employee with columns eid, ename, esal. I want to retrieve all the rows. can anyone tell me what will be the SQL procedure to retrieve all the columns. I want to retrieve all the columns which are corresponding to eid column which is given in table.

Thanks in Advance

Jiteendra Sampathirao · Answer

Hi use out parameter to get singe values(mostly used to know the status means query run successfully or not).... To get more values write the select query in stored procedure and use the SqlDataReader add the values like this cmd.Parameters.Add(New SqlParameter(c_id SqlDbType.Int)).Value = ID run command.ExecuteReader command....

Suthish Nair · Answer

you need SP or sql select query? select * from table where id = 1