SQLServer 存储过程调用

带有输入参数和输出的存储过程调用

在sql server中调用方式
简便执行方式
DECLARE
@country char(2),
@region nvarchar(255),
@city nvarchar(255)

exec p_dbip_city_sByIp N’103.10.10.10’,
@country OUTPUT ,
@region OUTPUT ,
@city OUTPUT
select @country,@region,@city

标准执行方式

USE [数据库名]
GO

DECLARE @return_value int,
@country char(2),
@region nvarchar(255),
@city nvarchar(255)

EXEC @return_value = [dbo].[存储过程名]
@ip = N’103.10.10.0’,
@country = @country ,
@region = @region OUTPUT,
@city = @city OUTPUT

SELECT @country as N’@country’,
@region as N’@region’,
@city as N’@city’

SELECT ‘Return Value’ = @return_value

GO