/**
 * This is a demo procedure using AdventureWorks2012 database
 * return without error code
 * @params id int
 */
IF OBJECT_ID('dbo.test') IS NOT NULL DROP TABLE dbo.test;
SELECT * INTO dbo.test FROM HumanResources.Employee WHERE BusinessEntityID > ?; 
  |