Sign Up Login


  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

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

why would you call update statistics? : Sql server database administration

0 Answers  

Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  

Explain optimistic and pessimistic concurrency?

0 Answers  

what is differece between union and union all

6 Answers  

What method is used by the Command classes to execute SQL statements that return single values?

0 Answers   B-Ways TecnoSoft,

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

What is the maximum length of an alert name?

0 Answers  

How to Run a Query on a Remote SQL Server?

2 Answers  

Find nth lowest salary or get nth lowest salary?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories