create procedure prctrial @firstname char(5), @l

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

Question Posted / chandra rekha

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How display code or Text of Stored Procedure using Sql query in Sql Server ?

598

Is sql server is free?

535

What is a heap?

615

What is sparse columns of sql server 2008?

600

What is the difference between SQL notification and SQL invalidation?

585

How many columns can exist together per table?

701

Explain try...catch with sql server?

596

Why variables called the most powerful component of ssis?

589

What is the use of custom fields in report?

556

how will add additional conditions in sql?

572

Can we add our custom code in ssis?

542

Explain the purpose of indexes?

540

What is difference between stored procedure and user defined function?

545

Explain what is the function of sql server agent windows service?

542

Can a cursor be updated? If yes, how you can protect which columns are updated?

515