createsp.sql

本代码展示了使用DB_LIB库对SQL SERVER的连接和各种操作的实例。

-- Select the default database of the user. For example, if the
-- default database is master, then execute the following two
-- lines before creating the procedure 'rcptest'
-- use master
-- go

create procedure rpctest
         (@param1 int out,
          @param2 int out,
          @param3 int out,
          @param4 int)
     as
     begin
         select 'rpctest is running.'
         select @param1 = 11
         select @param2 = 22
         select @param3 = 33
         select @param1

         return 123
     end