Which code segment should you use to create the table?

You are creating a stored procedure named usp1. Usp1 will create a table that will be used during the execution
of usp1. Only usp1 will be allowed to access the table.
You need to write the code required to create the table for usp1. The solution must minimize the need to
recompile the stored procedure.
Which code segment should you use to create the table?

You are creating a stored procedure named usp1. Usp1 will create a table that will be used during the execution
of usp1. Only usp1 will be allowed to access the table.
You need to write the code required to create the table for usp1. The solution must minimize the need to
recompile the stored procedure.
Which code segment should you use to create the table?

A.
CREATE TABLE oneTable

B.
CREATE TABLE ##oneTable

C.
CREATE TABLE #oneTable

D.
DECLARE oneTable TABLE



Leave a Reply 1

Your email address will not be published. Required fields are marked *