-- SQL Code created by Class::DBI declare @P1 int set @P1=NULL exec sp_prepare @P1 output, N'@P1 nvarchar(6)', N'SELECT orderid FROM Orders WHERE shipcountry = @P1 ', 1 select @P1