returning table from a stored procedure
-
Hello, I want to get all of the rows of a table in my database which are suit some criteria in a stored procedure. but ı dont know getting and returning table (multiple data) from a stored procedure. How can ı success this..
CREATE PROCEDURE procName @criteria1 int, @criteria2 char , ........ ...... SELECT bla, bla bla... FROM tableName WHERE bla = @criteria1 And ..... or using og JOIN. something like that. is it help? ------------------------------------ To study, study and only to study
-
CREATE PROCEDURE procName @criteria1 int, @criteria2 char , ........ ...... SELECT bla, bla bla... FROM tableName WHERE bla = @criteria1 And ..... or using og JOIN. something like that. is it help? ------------------------------------ To study, study and only to study