SQL part 1.0

1. The syntax for creating a View:

• Create View ViewName SELECT * FROM TableName

• Create View ViewName AS SELECT * FROM TableName

• Create View ProcName SELECT * FROM ViewName

• Create Procedure ProcedureName AS BEGIN Procedure Body END

Following code

"CREATE PROCEDURE spDisplayWelcome

AS BEGIN

PRINT 'WELCOME TO PROCEDURE in SQL Server'

END"

is an example of:

• Naming the user-defined stored procedures

• Stored procedure with parameters

• Executing the procedure

• Stored procedure without parameter

3. Which of these options are NOT correct way to call a Stored Procedure in SQL Server?

• EXEC Values

• EXECUTE ProcedureName VALUES

• ProcedureName VALUES

• EXEC ProcedureName VALUES

4. Which of these options are NOT correct way to delete a Stored Procedure in SQL Server?:

• DROP PROCEDURE ProcedureName

• Delete PROCEDURE ProcedureName

• Drop proc spGetEmployee1

• Drop Procedure spGetEmployee1

The parameters of a Stored Procedure:

• Simple, complex

• Updatable, non-updatable

• Defined, undefined

• Input, output

Output of the following code:

• 
• 
• 
• 

Output of the following code:

• 
• 
• 
• 

Output of the following code:

• 
• 
• 
• 

Output of the following code:

• 
• 
• 
• 

Output of the following code:

• There is no data found for your query

• 
• There is not enough parameters to procedure show

•