The following script creates the stored procedure sp_helloworld:
create procedure sp_helloworld (
@iso6391 char(8),
@phrase varchar(255) output
) as
select @phrase = phrase from phrases where iso6391 = @iso6391
The following script creates the phrases table in SQL Server:
create table phrases (
iso6391 char(8) PRIMARY KEY,
phrase varchar(255)
)