How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name?
Answer Posted / jerry joseph
EXEC ProcedureName 'FirstName', 'LastName'
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Which sql server table is used to hold the stored procedure script?
What are trace flags and mention a few common trace flags used with sql server?
What function does a database engine serve in the sql server?
Would you store your query in a ssrs report or a database server? State the reason why?
What is Dependency Injection and provide example?
What is a with(nolock)?
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?
How to use union to merge outputs from two queries together in ms sql server?
Explain about Normalization?
Explain the properties of the relational tables?
Tell me the phases a transaction has to undergo?
write an SQL query to list the employees who joined in the month of January?
Why do we use stored procedures in sql server?
How to use "begin ... End" statement structures in ms sql server?
How to Sync Two SQL Azure Databases?