View Single Post
  #2 (permalink)  
Old October 1st, 2004, 10:44 PM
jemacc jemacc is offline
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

try

CREATE PROCEDURE up_parmSel_state
   (@strWhere as varchar(255))AS
SELECT *
FROM state_t
WHERE <column> = @strWhere

go

EXEC up_parmSel_state @strWhere= 1
GO



Reply With Quote