EXEC ProcedureName 'FirstName', 'LastName'

How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name?

Question Posted / jerry joseph

Answer Posted / jerry joseph

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Which sql server table is used to hold the stored procedure script?

1004

What are trace flags and mention a few common trace flags used with sql server?

1137

What function does a database engine serve in the sql server?

1081

Would you store your query in a ssrs report or a database server? State the reason why?

157

What is Dependency Injection and provide example?

1178

What is a with(nolock)?

1025

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1014

How to use union to merge outputs from two queries together in ms sql server?

1134

Explain about Normalization?

1122

Explain the properties of the relational tables?

1029

Tell me the phases a transaction has to undergo?

1019

write an SQL query to list the employees who joined in the month of January?

1737

Why do we use stored procedures in sql server?

997

How to use "begin ... End" statement structures in ms sql server?

1115

How to Sync Two SQL Azure Databases?

121