Results 1 to 4 of 4
Jun 27, 2011, 09:23 #1
- Join Date
- Jul 2008
- 0 Post(s)
- 0 Thread(s)
How to call sql stored procedure in asp
I created a stored procedure in sql server and it worked when I called from sql QA (exec sp_name)
When I applied this to asp as:
sql = select * from tbl_student
where student_id in (exec dbo.sp_name)
It generated syntax error.
How do I call a stored procedure in asp? Or what is another way to make it work?