CREATE PROCEDURE SpRetrive($Squery nvarchar(16000)) BEGIN SET @stmt_str = $Squery; PREPARE stmt FROM @stmt_str; EXECUTE stmt; DEALLOCATE PREPARE stmt; END
CALL SpRetrive('select * from state')
Rs.584
0 Comments