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

Answer Posted / laxman

sp_help <stored_procedure_name>

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is collation sensitivity? Explain different types.

641


Explain the dirty pages?

660


What is the distinction amongst delete and truncate?

661


Mention the 3 ways to get a count of the number of records in a table.

625


How to create function with parameter in sql server?

644






Why normalization is used?

635


What is the use of sign function?

639


What is bit data type?

721


How to insert data into an existing table?

636


What is difference between temp table and cte?

630


Can you use order by when defining a view?

656


Explain the difference between cross join and full outer join?

586


How can I know what locks are running on which resource?

604


What are commit and rollback in sql?

658


Explain what are commit and rollback in sql?

602