USE [Northwind]
GO
/****** Object:  StoredProcedure [dbo].[sp_getOrders]    Script Date: 2014/7/7 17:32:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[sp_getOrders]   
 @orderID int = null   
 as   
if (@orderID is null )   
 begin  
 print ‘null‘   
 end   
else   
begin 
print ‘correct‘ 
 end 
 select * from Orders where OrderID = @orderID  

declare @i int ,@j int,@k int   
set @i = 1;  
set @j = 2;  
select @k=@i + @j  
exec sp_getOrders 10248   --调用存储过程，自动进入断点
 select @i;  
go