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 delete query?

0 Answers  

Explain active/passive and active/active cluster configurations?

0 Answers  

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

What do you understand by user-defined function in the sql server?

0 Answers  

What is de-normalization in sql database administration? Give examples?

0 Answers  




How do you clear a log file?

0 Answers  

Is index a datbase objects in sql server?

2 Answers  

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

What are the different types of columns types constraints in the sql server?

0 Answers  

What number aggregate functions are accessible there in sql?

0 Answers  

Explain sql server authentication modes?

0 Answers  

What is indexing a document?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories