You need to create a stored procedure that inserts a square value of a given integer. What is the best way to accomplish this?
(SQL Server has a built-in function, SQUARE, that will perform this action. Since you need to use a stored procedure, you use a built-in function inside a stored procedure. Creating a managed code procedure or function would cause too much system overhead since the calculation can easily be done within Transact-SQL. Creating a user-defined data type will not provide the functionality required.)