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 the use of @@spid?

0 Answers  

Can you get second highest salary from the table?

0 Answers   QuestPond,

What is join query?

0 Answers  

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,




what is the difference between openrowset and openquery?

0 Answers  

Why use “nolock” in sql server?

0 Answers  

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

What are relationships and mention different types of relationships in the dbms

0 Answers  

What is filestream?

0 Answers  

Explain few examples of stored procedure over triggers?

0 Answers   ADITI,

What is difference between primary key and foreign key?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories