8> Create PROC spTestReturns
9> AS
10> DECLARE @MyMessage varchar(50)
11> DECLARE @MyOtherMessage varchar(50)
12>
13> SELECT @MyMessage = 'Hi, '
14> PRINT @MyMessage
15> RETURN 100
16> SELECT @MyOtherMessage = 'Sorry'
17> PRINT @MyOtherMessage
18> RETURN
19> GO
1>
2> drop PROC spTestReturns;
3> GO
1>
2>