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

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

Do you know sql server 2008 introduces automatic auditing?

0 Answers  


How to change a login name in ms sql server?

0 Answers  


How to use transact-sql statements to access the database engine?

0 Answers  


Explain DBMS, RDBMS?

6 Answers  


what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,


What is the difference between value type and reference type?

0 Answers  


Is SET a SQL Keyword?

4 Answers   BitWise,


What do you mean by stored techniques? How would we use it?

0 Answers  


What is de-normalization and when do you do it?

3 Answers  


Explain how does the report manager work in ssrs?

0 Answers  


What does asynchronous call backs means?

0 Answers   Alcatel-Lucent,


Tell me what is difference between clustered and non clustered index?

0 Answers  


Categories