document.write('CREATE PROCEDURE [GetCustomerName]
');
document.write('
');
document.write('@CustomerID INT,
');
document.write('@FirstName NVARCHAR(30) OUTPUT,
');
document.write('@LastName NVARCHAR(30) OUTPUT AS
');
document.write('
');
document.write('SELECT
');
document.write(' @FirstName = [FirstName]
');
document.write(' @LastName = [LastName]
');
document.write('FROM
');
document.write(' [Customers]
');
document.write('WHERE
');
document.write(' [CustomerID] = @CustomerID');