Hello World SQL Scripts

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)
)