1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



How will oyu test the stored procedure taking two parameters namely first name and last name return..

Answer / chandra rekha

create procedure prctrial @firstname char(5),
@lastname char{5}
as
print @firstname+''+@lastname

prctrial Miss,Happy

output....Miss Happy

Is This Answer Correct ?    2 Yes 1 No

How will oyu test the stored procedure taking two parameters namely first name and last name return..

Answer / laxman

sp_help <stored_procedure_name>

Is This Answer Correct ?    3 Yes 3 No

How will oyu test the stored procedure taking two parameters namely first name and last name return..

Answer / jerry joseph

EXEC ProcedureName 'FirstName', 'LastName'

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More SQL Server Interview Questions

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

What is save transaction and save point?

0 Answers  

What is equi join with example?

0 Answers  

How to stop log file growing too big?

0 Answers  

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  




What is 3nf normalization?

0 Answers  

How many types of Cursor in SQL SERVER?

1 Answers  

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

How to delete exactly duplicate records from a table?

0 Answers  

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

What are the filtered indexes?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories