au_lname au_fname pub_name
-------------- ------------ --------------------
Green Marjorie Algodata Infosystems
Bennet Abraham Algodata Infosystems
O'Leary Michael Algodata Infosystems
MacFeather Stearns Algodata Infosystems
Straight Dick Algodata Infosystems
Carson Cheryl Algodata Infosystems
Dull Ann Algodata Infosystems
Hunter Sheryl Algodata Infosystems
Locksley Chastity Algodata Infosystems
(9 rows affected, return status = 0)
 ñëåäóþùåé ïðîöåäóðå showind2 ïàðàìåòðó @table ïðèñâàèâàåòñÿ ïî óìîë÷àíèþ çíà÷åíèå “titles”:
create proc showind2 @table varchar(30) = titles