Loading

Value Back from Stored Procedure

Angelina Erin

15y1.8k

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jiteendra Sampathirao15y ago
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 Nair15y ago
you need SP or sql select query? select * from table where id = 1